Home » SQL & PL/SQL » SQL & PL/SQL » simple PL/SQL question
simple PL/SQL question [message #37991] Tue, 12 March 2002 19:40 Go to next message
Rania
Messages: 2
Registered: March 2002
Junior Member
I must make a block in order to output a phrase.
In BEGIN if I put select, from which table should i call, since there is not a table.
So, which is the simplest way to do that?
thanks

Report message to a moderator

Re: simple PL/SQL question [message #37993 is a reply to message #37991] Wed, 13 March 2002 00:29 Go to previous messageGo to next message
Pratibha
Messages: 29
Registered: November 2001
Junior Member
Hi,

If no table name is present for your select, u can use
DUAL table like

select 'TEST' from dual

Bye

Report message to a moderator

exit; [message #37996 is a reply to message #37991] Wed, 13 March 2002 00:54 Go to previous message
Stephanie
Messages: 5
Registered: March 2002
Junior Member
Hi,

when the condition is wrong:
How can I exit the Query and NO Output File will be created?

Thanks,
Stephanie

Report message to a moderator

Previous Topic: sqlldr
Next Topic: code does not get executed, why??????
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 10:55:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.