View previous topic :: View next topic
|
Author |
Message |
joshkahn
New User
Joined: 30 Dec 2005 Posts: 8
|
|
|
|
What is the difference between FOR FETCH ONLY, FOR READ ONLY, WITH UR. |
|
Back to top |
|
|
joshkahn
New User
Joined: 30 Dec 2005 Posts: 8
|
|
|
|
iS THERE A SIMPLE WAY TO GET THE CURRENT WEEKS FRIDAY DATE? |
|
Back to top |
|
|
vasanthkumarhb
Active User
Joined: 06 Sep 2007 Posts: 275 Location: Bang,iflex
|
|
|
|
Hi joshkahn,
Quote: |
iS THERE A SIMPLE WAY TO GET THE CURRENT WEEKS FRIDAY DATE? |
Are you angry with forum,
Fetch only: is used to extract the records from the table.
Read only: means you read the records from the table, but not able to update the record.
UR: is un committed read, which is also called dirty read.
Regard's
Vasanth......... |
|
Back to top |
|
|
senthilssg
New User
Joined: 09 Dec 2005 Posts: 64 Location: USA
|
|
|
|
Hi ,
FOR FETCH ONLY or FOR READ ONLY in the DECLARE CURSOR statement
clause is used to indicate that the cursor does not modify data .
Becuase of above defintion , the cursor will be defined as read-only cursor and block fetch is also ensured .
UR :
WITH UR clause can be used at end of SELECT query to avoid the un necessary locks on READ-only database .
Thanks and Regards
Senthil |
|
Back to top |
|
|
joshkahn
New User
Joined: 30 Dec 2005 Posts: 8
|
|
|
|
I still don't understand the difference between FOR FETCH ONLY and FOR READ ONLY. Which is preferred and why? |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
joshkahn wrote: |
I still don't understand the difference between FOR FETCH ONLY and FOR READ ONLY. Which is preferred and why? |
That's because there is no difference. |
|
Back to top |
|
|
|