How to avoid using cursors? What to use instead of cursor and in what cases to do so?
No Answer is Posted For this Question
Be the First to Post Answer
Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d
How do you update a table in sql?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is a temporal table?
What is the purpose of design view?
i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.
What is pragma exception and how, when, where us
What are the different set operators available in sql?
difference between cursor and procedure in a package
Is record in oracle pl sql?
what is sql in mysql? : Sql dba
How to fetch alternate records from a table?
Oracle (3253)
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)