What are character functions?
- 0 Answers
- 802 Views
- I also Faced
- E-Mail Answers
How does an execution block start and end in pl sql?
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?
What will you get by the cursor attribute sql%found?
What is the limitation on the block size of pl/sql?
How does postgresql compare to oracle/db2/ms sql server/informix?
Give the structure of the function ?
Write a query to find the names of users that begin with "um" in sql?
What is a pl/sql block?
How many joins can you have in sql?
What is difference between group by and partition by?
Which is better join or subquery?
Can you select everything, but 1 or 2 fields, without writer's cramp?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
