Most voted questions under tag sql

+2 votes

1 answer

what are the constructs of a procedure, function or a package?

posted Dec 4, 2014 by Suchithra

+2 votes

1 answer

Can 2 functions have same name & input parameters but differ only by Return data type?

posted Dec 4, 2014 by Suchithra

+2 votes

1 answer

Can you call a stored function in the constraint of a table?

posted Dec 1, 2014 by Archana

+2 votes

1 answer

What are the various types of parameter modes in a procedure in PLSQL ?

posted Dec 1, 2014 by Archana

+2 votes

1 answer

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

posted Dec 1, 2014 by Archana

+2 votes

1 answer

What are the various types of Exceptions?

posted Nov 26, 2014 by Suchithra

+2 votes

2 answers

What is a Result Set? when is it created?

posted Nov 18, 2014 by Archana

+2 votes

2 answers

What is a primary key and why it is used?

posted Nov 12, 2014 by anonymous

+2 votes

1 answer

How does a syntax error differ from a runtime error in Oracle SQL?

posted Nov 11, 2014 by Archana

+2 votes

1 answer

unable to connect to the DB using Taod ORA-12571 TNS packet writer failure

posted Nov 7, 2014 by Archana

+2 votes

1 answer

What is lock escalation?

posted Oct 29, 2014 by Vidhya Sagar

+2 votes

1 answer

Explain different isolation levels in Oracle?

posted Oct 29, 2014 by Suchithra

+2 votes

1 answer

What is a transaction and what are ACID properties in Oracle?

posted Oct 29, 2014 by Suchithra

+2 votes

0 answers

What are user defined datatypes and when you should go for them in Oracle?

posted Oct 29, 2014 by Suchithra

+2 votes

1 answer

what is clustered index in Oracle?

posted Oct 22, 2014 by Vidhya Sagar

+2 votes

1 answer

Is space acquired in blocks or extents in Oracle?

posted Oct 22, 2014 by Archana

+2 votes

1 answer

What is pseudo columns in Oracle and what are their names?

posted Oct 21, 2014 by Suchithra

+2 votes

1 answer

What is the Difference between a post query and a pre query?

posted Oct 20, 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

What are Codd Rules in Oracle?

posted Oct 16, 2014 by Vidhya Sagar

+2 votes

1 answer

What is Row Chaining in Oracle?

posted Oct 14, 2014 by Suchithra

+2 votes

1 answer

Table Space, Data Files, Parameter File, Control Files in Oracle?

posted Oct 13, 2014 by Suchithra

+2 votes

2 answers

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

posted Oct 9, 2014 by Suchithra

+2 votes

1 answer

What are the OOPS concepts in Oracle?

posted Oct 8, 2014 by Vidhya Sagar

+2 votes

2 answers

How to insert more than one record using a single insert statement?

posted Oct 7, 2014 by Amit Kumar Pandey

+2 votes

1 answer

What is the difference between static and dynamic LOV?

posted Oct 7, 2014 by Vidhya Sagar

+2 votes

1 answer

How many minimum groups are required for a matrix report ?

posted Oct 7, 2014 by Suchithra

+2 votes

1 answer

How to update or insert row using single condition?

posted Sep 23, 2014 by Archana

+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

1 answer

How to list the tables from Schema with more than X rows in Oracle PLSQL

posted Sep 15, 2014 by Vidhya Sagar

+2 votes

1 answer

How to import data from file into database?

posted Sep 15, 2014 by Arun Gowda

+2 votes

2 answers

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

posted Sep 14, 2014 by Nimish

+2 votes

1 answer

can we update the ROWID in the oracle table

posted Sep 11, 2014 by Arun Gowda

+2 votes

1 answer

What is Change Data Capture (CDC) in SQL Server 2008?

posted Sep 10, 2014 by Muskan

+2 votes

1 answer

What is BCP? When is it Used?

posted Sep 10, 2014 by Merry

+2 votes

1 answer

What are indexed views?

posted Aug 22, 2014 by Merry

+2 votes

1 answer

What is Scope identity and When is it used?

posted Aug 8, 2014 by Muskan

+2 votes

2 answers

How to wite an update query with table joins?

posted Aug 8, 2014 by Khusboo

+2 votes

1 answer

How to delete duplicate rows from a table using a single query?

posted Aug 7, 2014 by Karamjeet Singh

+2 votes

1 answer

CTE vs Temp Tables

posted Jul 5, 2014 by Khusboo

+2 votes

1 answer

Please explain CTE (Common Table Expressions) with a simple example?

posted Jun 23, 2014 by Muskan

+2 votes

1 answer

How can I enable ODBC connection pooling?

posted Jun 11, 2014 by Nimish

+2 votes

1 answer

How to access excel sheet data in Oracle database?

posted May 13, 2014 by Rakesh Singh

+2 votes

3 answers

What is the difference between Primary Key and Unique Key?

posted May 5, 2014 by Sachin Dahda

+2 votes

1 answer

SQL: What is the use of CASCADE CONSTRAINTS?

posted Mar 25, 2014 by Deepak Chitragar

+2 votes

1 answer

SQL: Do you know the query with which i can find out when the SQL Server service had started ?

posted Mar 25, 2014 by Deepak Chitragar

+2 votes

1 answer

Joining null in SQL Server, Oracle and informatica?

posted Mar 21, 2014 by Madhavi Kumari

+2 votes

1 answer

What is SQL Azure?

posted Feb 26, 2014 by Avinash Shukla

+2 votes

0 answers

Optimize query to use sql over ruby iterators

posted Feb 24, 2014 by Bob Wise

+2 votes

1 answer

How to read data in a table with "SELECT" statements ?

posted Feb 2, 2014 by Mona Sharma