sql/oracle
-
hello everyone! I am trying to convert the below sql into oracle but i am having some issues with the variable declarations. ex. declare @md date set @md='7/1/2008' select @md in oracle how? any ideas? Thank you!
-
hello everyone! I am trying to convert the below sql into oracle but i am having some issues with the variable declarations. ex. declare @md date set @md='7/1/2008' select @md in oracle how? any ideas? Thank you!
-
run this is SQLDeveloper and set serveroutput on; declare md date default '01-JUL-08'; begin select '01-JUL-08' into md from dual; dbms_output.put_line( md ); end;
hth Al
thank you for reply ,that was what i want!
-
run this is SQLDeveloper and set serveroutput on; declare md date default '01-JUL-08'; begin select '01-JUL-08' into md from dual; dbms_output.put_line( md ); end;
hth Al
thank you for reply ,that is what i want!
-
run this is SQLDeveloper and set serveroutput on; declare md date default '01-JUL-08'; begin select '01-JUL-08' into md from dual; dbms_output.put_line( md ); end;
hth Al
-
J4amieC wrote:
All of that just to output a date WTF I'll stick to SQL Server
:laugh: I'll second that :)
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
-
Is this simplified if you use something like TOAD? While I have not used Oracle in a decade it was always lacking a good UI and we found TOAD the equivalent of the old SQL Query Analyser. Is this still the case.
Never underestimate the power of human stupidity RAH
-
Is this simplified if you use something like TOAD? While I have not used Oracle in a decade it was always lacking a good UI and we found TOAD the equivalent of the old SQL Query Analyser. Is this still the case.
Never underestimate the power of human stupidity RAH