What is rownum?
No Answer is Posted For this Question
Be the First to Post Answer
what is autonomouse transaction?
Can we insert in sql function?
What is Overloading of procedures ?
What is the basic difference between a sql and stored procedure ?
What is foreign key sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What are the types of join and explain each?
Why do we use partitions in sql?
What is sql and its types?
what is organisational index?
How to raise user-defined exception with custom sqlerrm ?
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 (3259)
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)