469,090 Members | 1,187 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

Simple SQL to display text

I was wondering - is there some part of sql that can display text?
I wanted to add simple instruictions to the beginning of an sql script
so the user understands what they're entering into the '&value' entry
of the SELECT portion of the script.

I know that anything with REM in the beginning is simply ignored.

Thanks for your help.
Jul 19 '05 #1
3 11033

"Joe Christl" <jc******@zdnetmail.com> wrote in message
news:e9**************************@posting.google.c om...
| I was wondering - is there some part of sql that can display text?
| I wanted to add simple instruictions to the beginning of an sql script
| so the user understands what they're entering into the '&value' entry
| of the SELECT portion of the script.
|
| I know that anything with REM in the beginning is simply ignored.
|
| Thanks for your help.

Not SQL, you're actually asking about SQL*Plus (Oracle very basic UI tool)

PROMPT for one line

DOC for multiple lines (terminate with #) -- or use a c-style multiple line
comment (equivalent of DOC...#)
lots more good stuff in the SQL*Plus manual! -- you might also want to check
out the ACCEPT statement

;-{ mcs

Jul 19 '05 #2
jc******@zdnetmail.com (Joe Christl) wrote in message news:<e9**************************@posting.google. com>...
I was wondering - is there some part of sql that can display text?
I wanted to add simple instruictions to the beginning of an sql script
so the user understands what they're entering into the '&value' entry
of the SELECT portion of the script.

I know that anything with REM in the beginning is simply ignored.

Thanks for your help.


If the front-end tool is SQLPlus then look up the prompt command in
the SQLPlus manual. You may also want to look at the accept
statements. Prompt and accept can be combined to ask for and get an
SQLPlus label variable.

HTH -- Mark D Powell --
Jul 19 '05 #3
Yes SQLPlus was what I was talking about.
PROMPT, DOC, & ACCEPT

Thanks Mark and Mark. :)
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by bob | last post: by
3 posts views Thread by Troy Wilson | last post: by
reply views Thread by yalanue | last post: by
3 posts views Thread by Joe Christl | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.