Why does %isopen return false for an implicit cursor?
Answer / kiran r
In Case of Implicit Cursor. it returns always false because the cursor automatically closes once it is Executed
| Is This Answer Correct ? | 0 Yes | 0 No |
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
what is isam? : Sql dba
Why use subqueries instead of joins?
How do I truncate a word?
what are numeric data types? : Sql dba
IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????
Is it important to partition hard disk?
what is user defined functions? : Sql dba
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
Why do we need cursor in pl sql?
What is a sql profiler?
Does asenumerable execute the query?
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)