What is the use of pl/sql table?
No Answer is Posted For this Question
Be the First to Post Answer
What is crud sql?
What is sql catalog?
what is subquery? : Sql dba
what are date and time intervals? : Sql dba
How to download oracle sql developer?
What is the default value of CHAR type?
What is the difference between a query and a report?
What are the types of triggers in sql?
Can a commit statement be executed as part of a trigger?
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...
Explain two easy sql optimizations.
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
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)