-
how to use reserved words???
Hi all
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.
rajorcl
-
in sql*plus "set define off"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|