OraFAQ Forum: Server Administration » how to pass variables into a sql script

Home » RDBMS Server » Server Administration » how to pass variables into a sql script

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to pass variables into a sql script [message #370189]

Fri, 29 December 2000 11:12

Charles Li
Messages: 2
Registered: December 2000

Junior Member

I want to pass the variable 's' to test.sql.
I have try to do the following, but its not working:
sqlplus app/passw@dev @test.sql 's'
Any ideas?

Thanks

Report message to a moderator

Re: how to pass variables into a sql script [message #370192 is a reply to message #370189]

Fri, 29 December 2000 15:13

sverch
Messages: 582
Registered: December 2000

Senior Member

If I undertstand you correctly,
u may use ACCEPT and PROMPT commands
(ACCEPT S PROMPT ('Enter Value: ')

Report message to a moderator

Previous Topic:	Primary Key Random Number
Next Topic:	problem with trigger and commit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 19 11:15:18 CDT 2026