What is difference between select statement and cursor
Answer Posted / akash
Using select..into statement u cannot fetch more than 1 rows.
Beside naming the same select statement as cursor explicitly allows user to options like OPEN,CLOSE,FETCH.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you mean by table in sql?
Can you skip header records while loading? : aql loader
how does a local variable is defined using t-sql? : Transact sql
How to change sql*plus system settings?
How do I run sql profiler?
How much does sqlite cost?
How can you load multi line records? : aql loader
What is server name sql?
What is a native sql query?
Can we debug stored procedure?
What is pls_integer in pl sql?
When is a declare statement required?
Explain normalization and what are the advantages of it?
What does the argument [or replace] do?
What is sql*loader and what is it used for? : aql loader