Why do we need cursor in pl sql?
No Answer is Posted For this Question
Be the First to Post Answer
How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.
How to know the last executed procedure?
need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
What is the use of triggers?
When the mutating error will comes? and how it will be resolved?
Can you select everything, but 1 or 2 fields, without writer's cramp?
Inline the values in PL/SQL, what does it mean.?
What is not equal in sql?
i need department wise top 2 employees salary.which logic i will use
Why do we use cursors?
how can we find the select statement is indexed or not?
What is row_number () in sql?
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)