Why are cursors used?
No Answer is Posted For this Question
Be the First to Post Answer
need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.
What is the difference between function and procedure in pl/sql?
Can pl sql procedure have a return statement?
What is sql data?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
How many unique keys can a table have?
how do you control the max size of a heap table? : Sql dba
What is normalization sql?
What is pragma exception and how, when, where us
how many sql ddl commands are supported by 'mysql'? : Sql dba
what are dynamic queries in t-sql? : Transact 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)