Sqlplus oracle : How can I run sql command on bash in 1 line?

Question

Can I convert this into 1 command line on bash in sqlplus? cause i want to automate it.

sqlplus / as sysdba
SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
exit

stackoverflow.com/questions/9462416/shell-one-line-query/… try the upvoted method — Vishnu Krishnan
– Vishnu Krishnan, Commented Jun 27, 2022 at 11:43

Sodved · Accepted Answer · 2012-06-28 04:50:44Z

16

You won't need the exit with automation because it should exit on end of file anyway. So on one line you could do:

echo 'EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);' | sqlplus / as sysdba

answered Jun 28, 2012 at 4:50

Sodved

8,6272 gold badges34 silver badges47 bronze badges

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

3 Comments

Kit Ho Over a year ago

Thanks. this would be the best answer as i don't want to create additional .sh or .sql at all

Mahfud Harun Over a year ago

I try this command with select query but nothing happened. It just login and then disconnect. What should I do?

Sodved Over a year ago

Sounds like you're missing a ; or / (on a line of its own) to actually run the command. Just a guess, you'll need to provide more details for a better answer

Neerav · Accepted Answer · 2013-03-22 15:03:45Z

6

sqlplus user/password@host @file.sql

answered Mar 22, 2013 at 15:03

Neerav

1,4395 gold badges17 silver badges25 bronze badges

Comments

Jie Hou · Accepted Answer · 2012-06-28 04:04:29Z

3

you can wirite by follow in a shell

#!/bin/bash
sqlplus / as sysdba <<EOF
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
exit
EOF

or you can put this commond into a procedure

answered Jun 28, 2012 at 4:04

Jie Hou

414 bronze badges

Comments

Iľja · Accepted Answer · 2012-06-28 05:31:24Z

0

sqlplus /nolog @your_script.sql

answered Jun 28, 2012 at 5:31

Iľja

5235 silver badges14 bronze badges

2 Comments

Frank Schmitt Over a year ago

That won't work, since /nolog prevents SQL*Plus from logging on to the database.

Iľja Over a year ago

Of course it won't - without putting the connect command into the script.

Collectives™ on Stack Overflow

Sqlplus oracle : How can I run sql command on bash in 1 line?

4 Answers 4

3 Comments

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related