Simple SQL to display text

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Joe Christl
    #1

    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.
    Tags: None
    • Mark C. Stock
      #2
      Re: Simple SQL to display text


      "Joe Christl" <jchristl@zdnet mail.comwrote in message
      news:e9cd3ea2.0 402190940.6b465 ce1@posting.goo gle.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.

      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



        Comment

        • Mark D Powell
          #3
          Re: Simple SQL to display text

          jchristl@zdnetm ail.com (Joe Christl) wrote in message news:<e9cd3ea2. 0402190940.6b46 5ce1@posting.go ogle.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 --

            Comment

            • Joe Christl
              #4
              Re: Simple SQL to display text

              Yes SQLPlus was what I was talking about.


              PROMPT, DOC, & ACCEPT

              Thanks Mark and Mark. :)

                Comment

                Previous template Next
                Working...