Why do we need cursor in pl sql?
No Answer is Posted For this Question
Be the First to Post Answer
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.
Why stored procedure is better than query?
What is recursive stored procedure?
write a query to delete similar records in different tables with same structure
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
What is the difference between DELETE, TRUNCATE, and DROP?
What is sql profiler in oracle?
How can we debug in PL/SQL?
Where not exists in sql?
What are the different types of constraints?
<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?
What do you mean by stored procedures?
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)