Title: ampersand problem
Why is this code not working for me
declare
code number(3):=0;
edate date;
begin
code:=111;
edate:=to_date('01-01-2001','dd-mm-');
dbms_output.put_line('actual data '||code ||','||edate);
@abc code edate
dbms_output.put_line('hello');
end;
/
abc.sql
');
end;
/
abc.sql
declare
my_code number(3);
my_date date;
begin
my_code:=1;
my_date:='2';
dbms_output.put_line('date in abc '||my_code ||','||my_date);
end;
/
-Original Message-
From: Swapna_Chinnagangannagari
Sent: Friday, October 05, 2001 12:27 PM
To: '[EMAIL PROTECTED
Title: OT Start Button
Hello All,
Sorry for posting a OT.
How can i change the text of the START button.
I'm using windows'95.
Regards
Swapna
Title: Sql query
Hello Friends I am struck up with typical problem.
I got this problem while querying data from Oracle Tables.
I can't explain the problem as it is with my project business jargons so
I am formulated the problem in following way.
Let us assume that table and data of it as
the order by
clause you see above. Ditch it if it should be something else.
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
-Original Message-
Swapna_Chinnagangannagari
Sent: Sunday, September 09, 2001 9:45 PM
To: Multiple recipients of list ORACLE-L
Hello Friends I am struck up
Title: RE: simple sql problem
Hello Raja,
You can try this way
1)select x+y sum1 from blah
2)col sum1 format 09.99
3)select x+y sum1 from blah
rgds
swapna
-Original Message-
From: Viraj Luthra [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 12:31 PM
To: Multiple
Title: RE: simple sql problem
but this will append 0 to numbers 1 (sum (a+b) 1)
which is not the requirement
-Original Message-
From: Pulikkol Kumar [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: simple sql problem