script question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: script question

  1. #1
    Join Date
    Apr 2002
    Posts
    135
    hai i have created a script in which i create tables.

    i will connect as internal to sqlplus and should run the script to create tables in another user's schema.

    the script will be as follows

    create table "&owner".table1(....)
    /
    create "&owner".table2(....)
    /

    actually i need to give the owner name input only once and this value has to be substituited for other
    input owner variables also.What should i do.


    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Lookup substitution variables in sql plus.You should be using && instead of a single & in front of teh variable name.

    somethin like

    create table "&&owner".table1(....)

    regards
    Hrishy

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