Explain the difference between cursor declared in procedures and cursors declared in the package specification?
No Answer is Posted For this Question
Be the First to Post Answer
What is the basic form of sql query?
What are the different types of a subquery?
Why do we create views in sql?
What is a temp table?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
Write a query to find five highest salaries from EMP table. (there is a column SALARY)
24 Answers Cap Gemini, iNautix,
What is the difference between cross join and natural join?
need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
What is oracle sql developer?
Why we use triggers in mysql?
what is constraining table?
write a query to delete similar records in different tables with same structure
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)