Are you sure you need SQLPlus and not Oracle SQL Developer? The command-line SQLPlus is useful for some things, but most development is much easier with an IDE like Oracle SQL Developer.

May 13, 2014 · 2 Your sqlplus line looks correct, verify the following: You can connect as sysdba on the database server itself. You can connect as the user you are trying to on the database server itself. …

Apr 23, 2012 · I have a .sql file, which is a bunch of oracle pl/sql commands and I want to create a shell script to run these commands. Suppose that user/pass@server is my credentials. What will be the …

Oct 28, 2009 · Is it possible to do something like this? $ sqlplus -s user/pass "select 1 from dual" or $ echo "select 1 from dual" | sqlplus -s user/pass I know I can put select 1 from dual in a file and do th...

Feb 15, 2012 · I want to connect to an oracle database located on another host using sqlplus. This page suggested adding an item on my tnsnames to connect to that database local_SID = (DESCRIPTION …

Feb 3, 2017 · Am little new to shell script and would like to know the use of -s option [sqlplus -s] in shell script. Thanks in advance.

Mar 12, 2009 · But is it possible to just run a single command with a similar syntax, without a whole separate script file? As in: c:\>sqlplus username/password@databasename @execute …

Nov 29, 2013 · What I'd rather like is either a horizontal scroll bar to appear or somehow send the output to less I run following statements in SQLPlus - SET LINESIZE 32000; SET PAGESIZE 40000; SET …

Mar 13, 2009 · I want to extract some queries to a CSV output format. Unfortunately, I can't use any fancy SQL client or any language to do it. I must use SQLPLUS. How do I do it?

Apr 13, 2013 · Using sqlplus.exe I'm looking for a way to write sqlplus output to a file. Is there anyway I can do that, currently the output is written only to the console.