how a reference cursor works?what all adnvantages are gained with it..specify the situation?
TCS,
4 11383what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?
TCS,
3 16152
Can we connect to postgresql using sql developer?
How do you remove duplicate records from a table?
how many values can the set function of mysql take? : Sql dba
Explain the difference between sql and mysql.
How does index help in query performance?
When is a declare statement required?
What is the use of prepared statement?
what is difference between delete and truncate commands? : Sql dba
what is sql? : Sql dba
What is the difference between pl and sql?
what are wild cards used in database for pattern matching ? : Sql dba
How do you remove duplicates without using distinct in sql?
What is on delete restrict?
Is sql difficult?
what are tables and fields? : Sql dba