Why do we use procedures in sql?
No Answer is Posted For this Question
Be the First to Post Answer
explain primary keys and auto increment fields in mysql : sql dba
How collections are improve the performance?
What are the different types of a subquery?
How many databases can sql express handle?
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 are system versioned tables?
what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )
What is the difference between between and in condition operators?
function can return multiple value?how give give sample coding
2 Answers 3i Infotech, CTS, Excelity Global, UHG,
How can we overcome recursive triggers in SQL?
What is not equal in sql?
What is the purpose of cursors in pl/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)