Most viewed questions under tag sql

+4 votes

1 answer

How to check if a Constraint exists in Sql server?

posted Nov 3, 2014 by Khusboo

+4 votes

1 answer

Sending mail to tag followers using PHP

posted Feb 7, 2014 by Seekha Dash

+1 vote

1 answer

Oracle: How to update COMPLEX VIEW?

posted Sep 8, 2015 by Vidhya Sagar

0 votes

1 answer

Oracle: How display the names of employees who are working in the company for the past 5 years?

posted Jun 12, 2015 by Kunal Kapoor

+2 votes

2 answers

What is the difference between MAX () and GREATEST () Functions in Oracle?

posted Aug 12, 2015 by Archana

+2 votes

1 answer

What is difference between Update and Alter commands?

posted Jul 27, 2015 by Suchithra

+4 votes

2 answers

What is the difference between SQL, MySql, Sqlite, Sqlite3

posted Mar 10, 2015 by anonymous

+1 vote

2 answers

How to check the Leap Year using Function in Oracle SQL

posted Sep 15, 2014 by Archana

0 votes

1 answer

SQL: Display the list of employee who have joined the company before 30-jun-90 or 31-dec-90?

posted Jun 4, 2018 by Deepika Goutam

+2 votes

2 answers

how to write a query that results an pyramid structure in Oracle SQL

posted Sep 16, 2014 by Archana

+2 votes

2 answers

What are the different types of JOINS in SQL and MYSQL?

posted Sep 14, 2014 by Nimish

+3 votes

1 answer

how to find common columns in two tables?

posted Feb 23, 2015 by Muskan

+1 vote

1 answer

How does one select EVERY Nth row from a table In Oracle?

posted May 28, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: What is the difference between SIMPLE and COMPLEX VIEWS?

posted Sep 8, 2015 by Vidhya Sagar

+1 vote

1 answer

what are the steps Required to Developing a New Form in oracle Apps?

posted Nov 20, 2015 by Kunal Kapoor

+2 votes

1 answer

Interview question: Which of the following is not a schema object Oracle?

posted Jan 30, 2015 by Archana

+1 vote

1 answer

How to display employee name and annual salary for all employees?

posted Jun 9, 2015 by Suchithra

+1 vote

1 answer

Oracle: What is the maximum no. of statements that can be specified in a trigger statement?

posted Dec 10, 2014 by Suchithra

+2 votes

1 answer

Informatica: how to get the auto-generated primary key of a table in Informatica mapping?

posted Oct 17, 2014 by Amit Sharma

+2 votes

1 answer

How to display names of employees who do not earn any commission in Oracle?

posted Jun 11, 2015 by Viswas Kumar

+2 votes

1 answer

Can you have two functions with the same name in a PL/SQL block?

posted Dec 1, 2014 by Archana

0 votes

1 answer

Oracle: What is the difference between foreign key and reference key?

posted Jan 16, 2015 by Suchithra

+1 vote

1 answer

What is the difference between Transaction and a Query?

posted Aug 4, 2015 by Suchithra

+1 vote

1 answer

What is the difference between SQL and SQL*PLUS commands?

posted Jun 30, 2015 by Vidhya Sagar

+2 votes

2 answers

What is the difference between candidate key, unique key and primary key in Oracle?

posted Oct 9, 2014 by Suchithra

+3 votes

1 answer

Real life example for Outer join and Inner join.

posted Jun 19, 2014 by Khusboo

0 votes

1 answer

what are the steps Required To Create a FIND WINDOW in Oracle Apps?

posted Nov 25, 2015 by Archana

+3 votes

1 answer

Can we define exceptions twice in same block in PLSQL?

posted Dec 1, 2014 by Archana

+2 votes

2 answers

Oracle: If a unique key constraint on DATE column is created, will it validate the rows that are inserted with sysdate?

posted Aug 21, 2015 by Kunal Kapoor

+2 votes

1 answer

What are the difference between DDL, DML, DQL, TCL and DCL commands?

posted Jul 15, 2015 by Archana

+1 vote

3 answers

What is the use for CHECK constraint in SQL?

posted Jun 30, 2018 by anonymous

+2 votes

1 answer

what is Positional and Named Notation in Oracle?

posted Apr 29, 2015 by Archana

+4 votes

1 answer

SQL: How to SELECT * INTO [temp table] FROM [stored procedure]

posted May 28, 2014 by Khusboo

+1 vote

1 answer

How we can get nth max salary from Employee Table (EMP_ID, Salary)

posted Feb 1, 2015 by Garima Gupta

+1 vote

1 answer

Oracle: What is the effect of synonym and table name used in same Select statement?

posted Jan 14, 2015 by Vidhya Sagar

+2 votes

3 answers

What is use for SQL Injection?

posted Jun 30, 2018 by Puneet Batra

+1 vote

1 answer

What is the difference between deleting and truncating of tables in Oracle?

posted Oct 15, 2014 by Suchithra

+3 votes

1 answer

What is the use of NULLIF in Oracle?

posted Aug 10, 2015 by Suchithra

+1 vote

1 answer

Oracle: What is the maximum number of triggers, can apply to a single table?

posted Mar 23, 2015 by Suchithra

+1 vote

1 answer

What is the difference between SQL and SQL*PLUS?

posted Sep 24, 2014 by Archana

+1 vote

2 answers

Oracle: I want to use a view to update a table. Is it possible?

posted Feb 9, 2015 by Suchithra

+1 vote

1 answer

A table named fruit has the attributes "ID", "Fruit name" and "Basket No":

posted Jun 15, 2015 by Shivaranjini

0 votes

2 answers

How to display the names of all employees who are working in department number 10 in Oracle?

posted Jun 9, 2015 by Vidhya Sagar

+2 votes

1 answer

What is the difference between COUNT (), COUNT (*) Functions in SQL?

posted Aug 5, 2015 by Archana

+3 votes

2 answers

What is the difference between GROUP BY and ORDER BY in Sql/MySql?

posted May 7, 2014 by Sachin Dahda

0 votes

2 answers

how to write a query to select Nth row from a table in Oracle SQL?

posted Sep 22, 2014 by Archana

+2 votes

0 answers

Why select * from dba_users shows total number of rows selected but for normal table it won't shows the count of rows?

posted Feb 21, 2017 by Chinmoy Padhi

+1 vote

2 answers

In SQL how to INSERT, UPDATE or DELETE record in one statement

posted Oct 7, 2014 by Amit Kumar Pandey

+2 votes

1 answer

How many minimum groups are required for a matrix report ?

posted Oct 7, 2014 by Suchithra

0 votes

1 answer

Oracle: What is the difference between a view and a synonym?

posted Jan 13, 2015 by Archana