Home » SQL & PL/SQL » SQL & PL/SQL » Update
Update [message #295385] Tue, 22 January 2008 04:15 Go to next message
monicaminj2000
Messages: 1
Registered: January 2008
Junior Member
could youplease tell me wat dis statement is going to do????


updateSql:='Update ' || DataTable || ' Set RECORDSTATUS = :1, RESPONSEXML = EMPTY_CLOB() , RECORDRESULT = :2, RECOVERYNUMBER = :3 Where RECORDKEY = :4 RETURNING RESPONSEXML INTO :5';
Re: Update [message #295395 is a reply to message #295385] Tue, 22 January 2008 04:32 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
it is going to assign the value of 'Update ' || DataTable || ' Set RECORDSTATUS = :1, RESPONSEXML = EMPTY_CLOB() , RECORDRESULT = :2, RECOVERYNUMBER = :3 Where RECORDKEY = :4 RETURNING RESPONSEXML INTO :5'
to the string variable updatesql for use within an execute immediate statement later in your procedure.

I would suggest that yopu do a dbms_output of the variable to see exactly what string has been built.

PS
wat and dis are not words. please refrain from using IM speak on these forums.
1. It makes it more difficult to understand your post.
2. It is unprofessional.
3. It is irritating to most people.
Cheers

[Updated on: Tue, 22 January 2008 04:34]

Report message to a moderator

Re: Update [message #295421 is a reply to message #295385] Tue, 22 January 2008 05:23 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

And this LINK may provide you detailed story .

Thumbs Up
Rajuvan
Previous Topic: select query
Next Topic: Run string as SQL statement
Goto Forum:
  


Current Time: Wed Dec 07 18:12:15 CST 2016

Total time taken to generate the page: 0.05301 seconds