What is execution plan in sql?
No Answer is Posted For this Question
Be the First to Post Answer
Is it mandatory for the primary key to be given a value when a new record is inserted?
Who is the owner of mysql database?
how can we repair a mysql table? : Sql dba
What is sql key?
Define select, insert, create, delete, update, drop keywords
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is the use of partition by in sql?
Describe sql comments?
write a query to delete similar records in different tables with same structure
What is the use of stored procedures?
How to avoid duplicate records in a query?
What is rownum and rowid?
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)