What is the difference between explicit and implicit cursors in oracle?
- 0 Answers
- 518 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75
How bulk collect improves performance?
What is union and union all keyword in sql?
What are crud methods?
What is sqlite used for?
Which data dictionary views have the information on the triggers that are available in the database?
I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL
5 Answers Doyensys, Infosys, Metric Stream,
Can unique keys be null?
How long will it take to learn pl sql?
Why stored procedure is faster than query?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Which nosql database is best?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
