Recent posts 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

+1 vote

1 answer

Can functions be over loaded?

posted Dec 3, 2014 by Archana

+1 vote

1 answer

What is Over Loading and what are its restrictions?

posted Dec 3, 2014 by Archana

+1 vote

1 answer

How can I get the source code for a function or a procedure or a package from the database?

posted Dec 2, 2014 by Archana

+1 vote

2 answers

Can some body give me some example of INSTEAD OF trigger?

posted Dec 2, 2014 by Archana

+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

+3 votes

1 answer

Can we define exceptions twice in same block in PLSQL?

posted Dec 1, 2014 by Archana

+2 votes

1 answer

What are the various types of Exceptions?

posted Nov 26, 2014 by Suchithra

+1 vote

1 answer

Can one read/write files from PL/SQL?

posted Nov 26, 2014 by Suchithra

+1 vote

1 answer

What DBMS package should I use to manipulate the long column in Oracle 7

posted Nov 24, 2014 by Archana

+1 vote

1 answer

How does one get the value of a sequence into a PL/SQL variable?

posted Nov 24, 2014 by Archana

+1 vote

0 answers

Polish char is getting changed to a differerent char when loading into Oracle

posted Nov 24, 2014 by Amit Sharma

+1 vote

1 answer

What are the two ways to specify a column alias?

posted Nov 19, 2014 by Suchithra

+1 vote

1 answer

How can I view the dependencies of a PL/SQL block?

posted Nov 19, 2014 by Suchithra

+1 vote

1 answer

Can one only retreive rows X to Y from a table?

posted Nov 18, 2014 by Archana

+2 votes

2 answers

What is a Result Set? when is it created?

posted Nov 18, 2014 by Archana

+1 vote

1 answer

what are INSTEAD OF triggers?

posted Nov 18, 2014 by Suchithra

+1 vote

1 answer

Can we use select in FROM clause of SQL select?

posted Nov 18, 2014 by Suchithra

+1 vote

1 answer

What are Explicit Cursor attributes?

posted Nov 13, 2014 by Suchithra

+1 vote

1 answer

How an Explicit cursor works?

posted Nov 13, 2014 by Suchithra

+1 vote

1 answer

How an Implicit cursor works?

posted Nov 12, 2014 by Vidhya Sagar

+1 vote

2 answers

Explain Implicit and Explicit cursors.

posted Nov 12, 2014 by Vidhya Sagar

+2 votes

2 answers

What is a primary key and why it is used?

posted Nov 12, 2014 by anonymous

+4 votes

2 answers

What is Commit, Rollback and Savepoint in context of SQL/Oracle?

posted Nov 11, 2014 by Archana

+2 votes

1 answer

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

posted Nov 11, 2014 by Archana

+3 votes

1 answer

Explain three different rules that apply to NULLs when doing comparisons?

posted Nov 11, 2014 by Archana

+3 votes

1 answer

What special operators does Oracle provide for dealing with NULLs?

posted Nov 11, 2014 by Archana

+1 vote

1 answer

can anyone tell me about SQL tuning tips?

posted Nov 7, 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

+1 vote

2 answers

can any explain about SQL TRUNCATE TABLE?

posted Nov 5, 2014 by Archana

+3 votes

1 answer

can any one explain about SQL Unions Clause in detail ?

posted Nov 5, 2014 by Archana

+4 votes

1 answer

add a Default Value Constraint

posted Nov 3, 2014 by Muskan

+4 votes

1 answer

How to check if a Constraint exists in Sql server?

posted Nov 3, 2014 by Khusboo

+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

+3 votes

1 answer

Difference between TRUNCATE, DELETE and DROP commands?

posted Oct 27, 2014 by anonymous

+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

+3 votes

3 answers

How many columns can table have in Oracle?

posted Oct 21, 2014 by Vidhya Sagar

+2 votes

1 answer

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

posted Oct 21, 2014 by Suchithra

+3 votes

1 answer

How do I keep a table synchronized with a query in SQL Server - ETL?

posted Oct 20, 2014 by Amit Sharma

+1 vote

1 answer

Can we disable database trigger in Oracle, if yes then how?

posted Oct 20, 2014 by Vidhya Sagar

+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

+1 vote

2 answers

What is Normalization in Oracle?

posted Oct 17, 2014 by Suchithra