How do I view an execution plan in sql?
No Answer is Posted For this Question
Be the First to Post Answer
I want to know last five transactions or records from emp table, from now?
What is difference between procedure and trigger?
What is Collation Sensitivity ? What are the various type ?
how many tables will create when we create table, what are they? : Sql dba
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...
Is sql sequential or random?
Advantages and disadvantages of stored procedure?
Are dml statements autocommit?
What is the use of nvl function?
What is the difference between a subquery and a join?
We have a CURSOR then we need BULK COLLECT?
What does where 1/2 mean 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)