|
I have several scripts that I would like to start from a menu presented to the SQLPlus user. Something like:
Please make a selection:
1: Do script a
2: Do script b
3: Do script c
I just need a point in the right direction, not a quick answer.
Started by Kyle Goddard on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
I'd got
&variablename is used to refer to the....
It can truncate lines if you don't set it up properly .
SQLPlus is a frontend about your SQLPlus settings.
It's hard to accomplish what you are trying to do with SQLPlus and/or PL/SQL.
|
|
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 this:
$ sqlplus -s user/pass @myFile.sql
but I'm wondering...
Started by andersonbd1 on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I assume this is *nix?
Use "here document":
sqlplus -s user/pass <<+EOF select 1 from dual):
$ echo 'select 1 from dual;'|sqlplus -s user/pw 1 1 $
I'm able to execute your exact query by just removed.)
echo "select 1 from dual;" |....
|
|
I'm running Oracle 11g on Linux and I'm trying to run a script which will create my database. This script runs fine on windows, but when I test it on Linux, I get the following error:
SP2-0556: Invalid File Name
The problem may be that the path to the...
Started by Stephen on
, 6 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Have you tried escaping the white space?
Try:
sqlplus [uname]/[pw] @'../database/My\ Schema/create like such:
sqlplus [uname]/[pw] @../database/My\ Schema/create_sequence.sql
Well along the lines of:
sqlplus [uname]....
|
Ask your Facebook Friends
|
I need to do some structural changes to a database (alter tables, add new columns, change some rows etc) but I need to make sure that if something goes wrong i can rollback to initial state:
All needed changes are inside a SQL script file. I don't have...
Started by sakana on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The import utility will read....
Take a look at export/import consistent mode).
I wouldn't use sqlplus to do this.
An alternate approach might be to create a new schema that contains your modified structures them on a production environment.
|
|
By default sqlplus truncates column names to the length of the underlying data type. Many of the column names in our database are prefixed by the table name, and therefore look identical when truncated.
I need to specify select * queries to remote DBAs...
Started by Chris Noe on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You might be able to automate the ALL_TAB_COLS view for the schema and table, and then create the script dynamically with a format.
I don't think sqlplus offers the functionality you are requesting.
|
|
Is there an easy and fast way to quickly perform a select of a BLOB value from Oracle, copy the result in a notepad and run the corresponding insert in another Oracle to insert data? Data is much longer than 4 K.
I cannot use external tools or copy files...
Started by massimogentilini on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Can you create a database link in either of the databases.
Table@destination_tns_alias CREATE dest_table_name ( column_list) USING SELECT column_list FROM source_table_name done any work on that since Oracle8).
|
|
Using Oracle 10g with our testing server what is the most efficient/easy way to backup and restore a database to a static point, assuming that you always want to go back to the given point once a backup has been created.
A sample use case would be the...
Started by crackity_jones on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Some articles you may.
You could use a feature in Oracle called Flashback which allows you to create a restore point sqlplus script that destroyed the DB then imported the dump file over the top.
|
|
Hi, I would appreciate a little expert help please.
in an SQL SELECT statement I am trying to get the last day with data per month for the last year. Example, I am easily able to get the last day of each month and join that to my data table, but the problem...
Started by Mathieu Longtin on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Of thing a lot, see if you can create an index over computed columns that hold cast(coll_date.
|
|
Hi,
I am using RHEL5 and have just copied instant client 11.2.0.0.2 from download section.
When I try to connect to sqlplus it gives me following error:
$ sqlplus
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0...
Started by user6506887 on
, 9 posts
by 8 people.
Answer Snippets (Read the full thread at oracle):
Where sqlplus
$ type sqlplus
3 is the output of "locate -r /sqlplus\$"
- What is in your instant client directory?
Yours,
Laurenz Albe You an ....
Oracle Home
$ echo $ORACLE_HOME
2.
sqlplus?
type sqlplus Please show:
1.
|
|
Hi everyone,
I have been charged with the task of creating an Oracle server on a CentOS VM. Installation and configuration is complete and SQL is working fine for the database admin user "oracle." I copied the environment variables to the .bashrc file...
Started by 910006 on
, 4 posts
by 2 people.
Answer Snippets (Read the full thread at oracle):
I need to create basic Linux user accounts that will have access to the database....
Here is where I need a little guidance...
Oracle." I copied the environment variables to the .bashrc file for "oracle" and SQLPLUS starts without a hitch.
|
