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

Thread: script question

  1. #1
    Join Date
    Apr 2002
    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

    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(....)


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