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 …

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 …

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 …

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 = …

Sep 20, 2016 · How can I run sqlplus.exe so that I can pass arguments to the script? @ECHO off // where HOST030 is a tnsnames alias to a machine, port, and instance sqlplus.exe …

Oct 1, 2024 · 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 …

Mar 12, 2009 · 6 sqlplus user/password@sid < sqlfile.sql This will also work from the DOS command line. In this case the file sqlfile.sql contains the SQL you wish to execute.

Unfortunately @@dir/file.sql works relative to sqlplus's current working dir, like @, so it means oracle will never be able to fix this defect, unless they invent @@@.

Sep 22, 2008 · I have a SQL script that creates a package with a comment containing an ampersand (&amp;). When I run the script from SQL Plus, I am prompted to enter a substitute …

Aug 19, 2016 · I have written couple of sql scripts in a text file and saved them with a .sql extension. I want to execute these scripts in the sql plus terminal without having to manually …