Top "Sqlplus" questions

SQL*Plus is a command-line interface for the Oracle RDBMS product.

Favorite SQL*Plus tips and tricks

So many times I just need a quick connection to an Oracle DB, where SQLPLUS handles the job. I imagine …

sql oracle sqlplus
Does SQLDeveloper support executing scripts?

I was trying to follow some instructions today, and it starts with the comment REM In SQLPlus I manually copy …

oracle sqlplus oracle-sqldeveloper
How do I pass arguments to a PL/SQL script on command line with SQLPLUS?

How do I pass arguments to a PL/SQL script on command line with SQLPLUS? I can call my PL/…

oracle sqlplus
How to install SQL * PLUS client in linux

I am working on AWS services. I have an ec2 ( centos ) instance. I need to configure SQL*Plus client on …

linux oracle amazon-ec2 centos sqlplus
SQLPLUS command line with Windows batch file

I want to create a batch file which will open the SQLPLUS [CLI] and will execute some stored sql file …

batch-file sqlplus oracle9i
Select into a temporary table in Oracle

I am trying to do something like the following, select * into temp from (select * from student); It gives me the …

oracle plsql sqlplus
How to run Oracle query with begin/end in SQL*Plus?

I have created a query block with begin/end and want to run that in SQL*Plus. But how can …

oracle sqlplus
Determining location of relevant tnsnames.ora file

I installed both the 32 and 64-bit Oracle 11g drivers. I search my PC looking for files with the name "tnsnames.…

oracle sqlplus toad
Managing error handling while running sqlplus from shell scripts

#!/bin/sh echo "Please enter evaluate database username" read eval_user echo "Please enter evaluate database password" read eval_pass …

oracle shell sqlplus aix
Connect SQLplus in oracle

I want to connect user sys in sqlplus of oracle but after I connect, I type like this: sqlplus sys …

oracle sqlplus