how to use reserved words???
I have a procedure and it has the following statement in it
p_statement_header := 'EMP ACCOUNT - TAX INVOICE & ADVICE OF PAY';
So when I try to create the procedure it asks me to input the value for advice.
Enter value for advice:
and I just press enter and everything goes fine. But I dont want it to ask me for the value and I use the following to get rid of it:
p_statement_header := 'EMP ACCOUNT - TAX INVOICE'||' & '|| 'ADVICE OF PAY';
Is there any other way other than this???????
Please let me know.
Thanks in advance.
in sql*plus "set define off"
Click Here to Expand Forum to Full Width