var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL statement - UPDATE
Following is my table structure :
Table Name : A
Col 1 : Query_Key Number(3)
Col 2: Query_text Varchar2(2000)
I would like to update the Query_txt column with the following value :
SQL> Update A
Set Query_txt = ' Select To_char(SYSDATE,'DD MON YYYY'), To_char(SYSDATE,'DD MM YY') from Dual'
where Query_key = 3;
The above statement is showing the following err msg :
ERROR at line 2:
ORA-00933: SQL command not properly ended
I can understand the problem is due to the single quotes, but unable to resolve.
Need your help.
There should be two apostrophes on date format:
SET query_txt =
' Select To_char(SYSDATE,''DD MON YYYY''), To_char(SYSDATE,''DD MM YY'') from Dual'
WHERE query_key = 3;