How would you pass hints to the sql processor?
No Answer is Posted For this Question
Be the First to Post Answer
define different types of trigger. : Sql dba
what are %TYPE and %ROWTYPE? what is the difference?
7 Answers ICICI, Saama Tech, Sail,
how can we optimize or increase the speed of a mysql select query? : Sql dba
What is a common use of group by in sql?
How do you get all records from 2 tables. Which join do you use?
Why commit is not used in triggers?
what is a trigger in mysql? : Sql dba
What is difference between table and view?
Define implicit and explicit cursors.
How many types of primary keys are there?
What is primary key secondary key alternate key candidate key?
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)