Interested to Buy Any Domain ? << Click Here >> for more details...
1.when will you use week refcursor and when will you use
strong ref cursor ?
2.what is the use of sql trace..how do you use it ?
3.can you please send all the sql plus commands...like set
line 6000....
- 1 Answers
- 5573 Views
- Satyam, I also Faced
- E-Mail Answers
Answer / gourvendra singh
Strong Ref Cursor: Strong ref cursor are predetermined and
so we cannot use query having different structure then the
defined one
Week Ref Cursor : Week Ref Cursor are not predetermined and
so we can use query having different structure then the
defined one.
With the help of SQL Trace we will get the result of the
query with the execution plan and statistics of the query.
It is very difficult to send you all the SQL Plus Command,
you can check the same in SQL Plus window under option menu
in Environment there you will find all the SQL plus
commands.
| Is This Answer Correct ? | 6 Yes | 2 No |
what is the cursor and use of cursor in pl/sql ?
Is left join inner or outer?
What is a temporal table?
Why cross join is used?
What are aggregate functions in sql?
Is ms sql is free?
What are few of the schema objects that are created using PL/SQL?
What is bind variable in pl sql?
What are the basic sql commands?
How do I enable sql encryption?
What are dml commands?
Which command is used to call a stored procedure?
-
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)
