Why is there a need for sqlcode and sqlerrm variables?
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
What is function and procedure?
How to recompile a already made trigger?
difference between pl/sql table and normal pl/sql table
I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
Which one is faster ienumerable or iqueryable?
What is a temp table?
Why do we use view in sql?
how to rename an existing column in a table? : Sql dba
What is dense_rank?
Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')
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)