If a cursor is open, how can we find in a pl/sql block?
No Answer is Posted For this Question
Be the First to Post Answer
what is the bond code in materialized view?
What is pl sql commands?
How many clustered indexes can be created on a table?
Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?
What is materialized view. What are different methods of refresh?
What is database migration?
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 prepared statement?
Why we use joins in sql?
Difference between views and materialized views?
Which language is used in sql?
What are actual parameters and formal parameters?
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)