Recent posts under tag sql

+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

+5 votes

1 answer

How to create a CSV file of any table by sql query in sql server?

posted Aug 3, 2015 by Mohammed Hussain

+2 votes

1 answer

What is the GRANT command with "WITH GRANT OPTION"?

posted Jul 31, 2015 by Kunal Kapoor

+2 votes

1 answer

What are the System and Object Privileges?

posted Jul 31, 2015 by Kunal Kapoor

0 votes

2 answers

How to see what privileges received to user by owner user?

posted Jul 30, 2015 by Viswas Kumar

0 votes

1 answer

How to see what privileges given by user to other users?

posted Jul 30, 2015 by Viswas Kumar

0 votes

1 answer

What is meant by SORTING and GROUPING?

posted Jul 29, 2015 by Vidhya Sagar

0 votes

1 answer

When do you use WHERE clause and when do you use HAVING clause?

posted Jul 29, 2015 by Vidhya Sagar

0 votes

1 answer

What is the significance of the & and && operators in PL SQL?

posted Jul 29, 2015 by Archana

0 votes

1 answer

What is the difference Rename and Alias in context of SQL/Oracle?

posted Jul 29, 2015 by Archana

+2 votes

1 answer

What is the use of INSERT ALL in SQL/Oracle?

posted Jul 27, 2015 by Suchithra

+2 votes

1 answer

What is difference between Update and Alter commands?

posted Jul 27, 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

+2 votes

1 answer

What are SQL Isolation levels and what is best for concurrency and avoiding deadlocks.

posted Jul 23, 2015 by Vrije Mani Upadhyay

+2 votes

0 answers

How SQL database stores Rows, Data pages, extents, in disk and memory?

posted Jul 23, 2015 by Vrije Mani Upadhyay

+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

+2 votes

1 answer

How Oracle identifies each record of Table uniquely?

posted Jul 17, 2015 by Kunal Kapoor

+3 votes

1 answer

What is INDEX and what are the advantages?

posted Jul 17, 2015 by Kunal Kapoor

+2 votes

1 answer

What is a dynamic SQL?

posted Jul 16, 2015 by Viswas Kumar

+1 vote

1 answer

IS 'DEFINE' a valid SQL statement?

posted Jul 16, 2015 by Viswas Kumar

+2 votes

1 answer

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

posted Jul 15, 2015 by Archana

+3 votes

1 answer

What is the difference between CHAR, VARCHAR, VARCHAR2 data types?

posted Jul 15, 2015 by Archana

+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

0 votes

1 answer

What are the data types allowed in a table?

posted Jul 13, 2015 by Suchithra

0 votes

1 answer

What are the large OBJECT types supported by the Oracle?

posted Jul 13, 2015 by Suchithra

+2 votes

1 answer

What is default database in MangoDB?

posted Jul 13, 2015 by Amit Kumar Pandey

+1 vote

2 answers

What is Deadlock in Oracle?

posted Jul 10, 2015 by Kunal Kapoor

+2 votes

1 answer

What is database link?

posted Jul 7, 2015 by Vidhya Sagar

+2 votes

1 answer

what are the Oracle database's physical and logical structure?

posted Jul 7, 2015 by Vidhya Sagar

+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

0 votes

2 answers

What is main feature of NULLIF Function in SQL?

posted Jul 1, 2015 by Amit Kumar Pandey

+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

+4 votes

0 answers

Variations for CASE in SELECTs (pros/cons)

posted Jun 30, 2015 by Manikandan J

+3 votes

1 answer

How would you handle NULL problems?

posted Jun 30, 2015 by Manikandan J

+4 votes

1 answer

What would you do to optimize slow-running queries?

posted Jun 30, 2015 by Manikandan J

+3 votes

1 answer

What is COALESCE?

posted Jun 30, 2015 by Manikandan J

0 votes

1 answer

Oracle: workaround for snapshots on tables with LONG columns?

posted Jun 26, 2015 by Kunal Kapoor

0 votes

1 answer

How does one find the next value of a sequence in Oracle?

posted Jun 26, 2015 by Kunal Kapoor

0 votes

1 answer

How can I change my Oracle password in Oracle8i?

posted Jun 26, 2015 by Kunal Kapoor