DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Define

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Posts
    103
    Hi,
    Can anybody tell me when do we should use Define. I know Define is used with Char. I am looking for a example.
    thankx in advance.
    When the going gets tough, the tough gets going

  2. #2
    Join Date
    Apr 2001
    Location
    UK
    Posts
    137
    Can you be more specific ? Do you mean DEFINE in SQL*Plus or something else ?

  3. #3
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    Hi akhil
    The DEFINE command is used to load a CHAR variable with data.This can be used only with character data.If numeric data is loaded be sure to use appropriate conversion if it will be used for comparison purposes.
    The EXAMPLE is

    SQL>DEFINE POS=MANAGER

    The above example assigns the text value "MANAGER" to the variable POS.If &POS is used in a script that follows,the value "MANAGER" will be substituted at runtime.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width