Interested to Buy Any Domain ? << Click Here >> for more details...
what is the uses of cusor
- 3 Answers
- 5767 Views
- Perot Systems, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / faize
when query is executed in oracle then result set is
produced & stored in the memory.Oracle allows the
programmer to access this resultset in the memory through
cursors
two types of cursors:
1.Explict cursor
2.Implict cursor
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ace dba
The DBA who has to performance troubleshoot you code when
you do row-at-a-time processing in a set-oriented database.
Or is that curser?
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kiran
it is the temporary space developed by the oracle server
when in an implicit cursor
and when a user wants to create a cursor then it is called
explicit cursor
so - any temporary place generated in the temporary memory
during the execution of sql query is called cursor
| Is This Answer Correct ? | 0 Yes | 3 No |
How to get last row id?
Can we insert data in view oracle?
Explain a synonym?
What are the extensions used by oracle reports?
Define Transaction ?
what is the difference between oracle enterprise edition and oracle express edition?
Explain can a view based on another view?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
Oracle General 
