Home » RDBMS Server » Server Administration » how to pass variables into a sql script
how to pass variables into a sql script [message #370189] Fri, 29 December 2000 11:12 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 00:26:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.