Most voted questions under tag sql

+1 vote

1 answer

Oracle: What are the advantages of VIEW?

posted Sep 7, 2015 by Suchithra

+1 vote

1 answer

Oracle: What are CYCLE/NO CYCLE in a sequence?

posted Sep 3, 2015 by Viswas Kumar

+1 vote

1 answer

What is the fastest way of accessing a row in a table?

posted Aug 31, 2015 by Suchithra

+1 vote

1 answer

Oracle: What is ON DELETE CASCADE?

posted Aug 20, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: What is a CONSTRAINT? What are its various levels?

posted Aug 20, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: What is the difference between IN & Exist?

posted Aug 19, 2015 by Archana

+1 vote

1 answer

Oracle: What is the difference b/w sub query and correlated sub query?

posted Aug 18, 2015 by Vidhya Sagar

+1 vote

1 answer

Oracle:Special operators used for sub query?

posted Aug 18, 2015 by Vidhya Sagar

+1 vote

1 answer

Oracle: What are the Limitations of sub query?

posted Aug 17, 2015 by Suchithra

+1 vote

1 answer

What are set operator in oracle?

posted Aug 17, 2015 by Suchithra

+1 vote

1 answer

What is MERGE statement (9i)?

posted Aug 13, 2015 by Viswas Kumar

+1 vote

1 answer

What is the use of CUBE in Oracle?

posted Aug 13, 2015 by Viswas Kumar

+1 vote

1 answer

What is the difference between Transaction and a Query?

posted Aug 4, 2015 by Suchithra

+1 vote

1 answer

What are various privileges that a user can grant to another user?

posted Aug 4, 2015 by Suchithra

+1 vote

1 answer

Can we change the data type and size in a table when data is there and when data is not there?

posted Jul 24, 2015 by Kunal Kapoor

+1 vote

1 answer

What is ALTER command? How we use it to Add a new column?

posted Jul 24, 2015 by Kunal Kapoor

+1 vote

1 answer

What are the advantages of clusters?

posted Jul 23, 2015 by Viswas Kumar

+1 vote

1 answer

How to drop a CLUSTER when CLUSTERED table exists?

posted Jul 23, 2015 by Viswas Kumar

+1 vote

3 answers

What are the Disadvantages of a CLUSTER?

posted Jul 22, 2015 by Archana

+1 vote

2 answers

What is the use of CLUSTER?

posted Jul 22, 2015 by Archana

+1 vote

1 answer

IS 'DEFINE' a valid SQL statement?

posted Jul 16, 2015 by Viswas Kumar

+1 vote

1 answer

Which datatype is used for storing graphics and images?

posted Jul 14, 2015 by Vidhya Sagar

+1 vote

1 answer

How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY?

posted Jul 14, 2015 by Vidhya Sagar

+1 vote

2 answers

What is Deadlock in Oracle?

posted Jul 10, 2015 by Kunal Kapoor

+1 vote

1 answer

How to display data Page Wise in SQL?

posted Jul 3, 2015 by Kunal Kapoor

+1 vote

1 answer

What is a Session in context of SQL?

posted Jul 1, 2015 by Vidhya Sagar

+1 vote

1 answer

What is Schema and Schema Objects in Oracle?

posted Jul 1, 2015 by Vidhya Sagar

+1 vote

1 answer

Update a single table based on data from multiple tables SQL Server 2005,2008

posted Jun 30, 2015 by Shivaranjini

+1 vote

1 answer

How to update multiple tables in sql server 2008 ?

posted Jun 30, 2015 by Shivaranjini

+1 vote

1 answer

How can I do an UPDATE statement with JOIN in SQL?

posted Jun 30, 2015 by Shivaranjini

+1 vote

1 answer

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

posted Jun 30, 2015 by Vidhya Sagar

+1 vote

1 answer

What is anonymous block using cursor?

posted Jun 25, 2015 by Priyadharshini Kunjithapatham

+1 vote

1 answer

How can one rename a column in a table in Oracle 8i?

posted Jun 24, 2015 by Archana

+1 vote

1 answer

How to create Nested SQL Cursors in sql server?

posted Jun 23, 2015 by Shivaranjini

+1 vote

1 answer

How to create Cursor inside cursor in sql server?

posted Jun 23, 2015 by Shivaranjini

+1 vote

1 answer

Oracle: How does one count/sum RANGES of data values in a column?

posted Jun 19, 2015 by Kunal Kapoor

+1 vote

1 answer

Oracle: How does one add a day/hour/minute/second to a date value?

posted Jun 17, 2015 by Archana

+1 vote

1 answer

SQL: Need help with Multiple Joins of Tables?

posted Jun 16, 2015 by Shivaranjini

+1 vote

1 answer

Help with Join operation in SQL

posted Jun 16, 2015 by Shivaranjini

+1 vote

1 answer

SQL: Get the highest number of each group and combine the result per parent column?

posted Jun 16, 2015 by Shivaranjini

+1 vote

1 answer

How to create a UNIQUE Key on a Column which is having multiple NULL values?

posted Jun 15, 2015 by Shivaranjini

+1 vote

1 answer

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

posted Jun 15, 2015 by Shivaranjini

+1 vote

1 answer

How to escape special characters when building SQL queries?

posted Jun 15, 2015 by Suchithra

+1 vote

2 answers

What is SQL and where does it come from?

posted Jun 15, 2015 by Suchithra

+1 vote

1 answer

sql query of EMP table?

posted Jun 12, 2015 by Kunal Kapoor

+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

Display employee number and total salary for each employee in Oracle?

posted Jun 9, 2015 by Suchithra

+1 vote

1 answer

How to display name and salary for all employees?

posted Jun 5, 2015 by Kunal Kapoor

+1 vote

1 answer

How to display the name and job for all employees?

posted Jun 5, 2015 by Kunal Kapoor

+1 vote

1 answer

How to display the details of all employees in Oracle?

posted Jun 3, 2015 by Archana