I need to call another sql file within an sql file using sql plus

Question

I need to call another sql file within an sql file using sql plus. This si the script i have so far and its not working. I have to code it in a unix vi file. I am new to this so would someone mind helping. thank you in advance.

 call=`$LIVE_SQL/sqlfile2.sql`
 if  &call = 0  then
   echo "ERROR: $LIVE_SQL/sqlfile2.sql file not found"
   exit 1
 fi

tvCa · Accepted Answer · 2014-11-24 19:24:44Z

0

The command to call other SQL files from within SQLPLUS is : start (or @)

Getting feedback from the SQL script : SQLPLUS is not Bash. It is possible, but not really beginner stuff.

answered Nov 24, 2014 at 19:24

tvCa

8267 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

I need to call another sql file within an sql file using sql plus

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related