difference between imlicit cursor and explicit cursor ?
Answer Posted / kiran
implicit generated by oracle server
explicit manually created by programmer to store the result
in the temporary space
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you know about normalization? Explain in detail?
How to call a sub procedure?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is transaction control statement and how many types of transaction control statement in Oracle?
What is the difference between pre-select and pre-query?
How many types of synonyms in Oracle?
Hi Can any one tell me what are the API's used in requisition import.
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Can group functions be mixed with non-group selection fields?
How to convert characters to dates in oracle?
How many data types are supported?
What are the oracle differences between nvl and coalesce
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Explain the use of constraints option in exp command.