Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sqlplus in shell script
Top Forums Shell Programming and Scripting Sqlplus in shell script Post 302857337 by rbatte1 on Thursday 26th of September 2013 05:58:48 AM
Old 09-26-2013
You might get away with indenting the EOF line with tabs, but only tabs. Copy and paste will normally replace it with spaces, so you have to be very careful.

For safety, you might need to end up with something that looks a bit odd like this:-
Code:
:
:
:
        select 'drop synonym "'||synonym_name||'"'||chr(59) from all_synonyms where owner = '${sch}';
        select '' from dual;
        select 'Drop TYPE "'||OBJECT_NAME||'" Force'||chr(59) from all_objects where object_type='TYPE' and owner='${sch}';
        select 'quit'||chr(59) from dual;

        quit;
EOF
        

    else
        echo "This is Other Env"
:
:
:


Robin
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

passing parameters from a shell script to sqlplus

Hi , I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script Right now no file is generated on the unix box...it is a... (2 Replies)
Discussion started by: phani
2 Replies

2. Shell Programming and Scripting

running shell script from sqlplus

I have a script which connects to different database servers using sqlplus. Is there a way by which I can run a shell command on that host from sqlplus? I know about 'host' command but it runs script on the local machine where the original script is running. Is there a way to run command on the... (9 Replies)
Discussion started by: dkr123
9 Replies

3. UNIX for Dummies Questions & Answers

Shell Script And SQLPLUS

i'm having real problems retrieving the returncode of my sqlplus-call. I found a lot of informations on the net, but havn't been able to get it running so far, so now i ask for some help ;) I do start the sqlplus out of my shell script with the parameters stored in the proc_clips.sql, which is... (6 Replies)
Discussion started by: maco_home
6 Replies

4. Shell Programming and Scripting

help me in sending parameters from sqlplus script to unix shell script

Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files.. Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this? Please tell me... (2 Replies)
Discussion started by: Hara
2 Replies

5. Shell Programming and Scripting

Call sqlplus in the shell script

Hi, I am writing a script to test database connection. If the first try fails, it will wait for 1 minutes and then try again. The script is as following: ........ for i in $ORACLE_SID do $ORACLE_HOME/bin/sqlplus $username/$password@$i <<! >/dev/null select * from tab; exit if ; then... (3 Replies)
Discussion started by: beaniebear
3 Replies

6. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Hi, I need help urgently for following issue. Pls help me to resolve this issue. I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql) I given... (6 Replies)
Discussion started by: praka
6 Replies

7. Shell Programming and Scripting

SQLPLUS within shell script

Hi I want to connect to the Oracle database using a username/password and get back the query result(a numeric value) in a variable, which I can then compare using a conditional. Can anybody help me with this. Thanks Gaurav (4 Replies)
Discussion started by: gaurav_1711
4 Replies

8. Shell Programming and Scripting

Want to learn/use SQLPLUS in shell script

Hi All, How i will use sqlplus in shell script? Can any one provide sample code which explain following: 1. Connect to oracle DB 2. Exceute select * from tablename 3. Release connection to the DB 4. Append output in file everytime when query executes. Thanks in advance (1 Reply)
Discussion started by: poweroflinux
1 Replies

9. Shell Programming and Scripting

SQLplus and Shell script problem

sql_rows=`sqlplus -s / <<EOF set heading off set pagesize 1000 set tab off set linesize 120 wrap off column "Path" format a15 --column "No_Of_files" format a10 select tablespace_name, substr(file_name,1,instr(file_name,'/',1,2)) as "Path" , count(*) as "No_Of_files" from dba_data_files ... (7 Replies)
Discussion started by: desibabu
7 Replies

10. Shell Programming and Scripting

sqlplus in shell script

Hi When I use sqlplus in shell script, I get sqlplus: command not found. ORACLE_HOME is not set. How to set ORACLE_HOME in unix? Thanks (3 Replies)
Discussion started by: vinoth_kumar
3 Replies

LEARN ABOUT DEBIAN

tcamgr

TCATEST(1)							   Tokyo Cabinet							TCATEST(1)

NAME

       tcamgr - the command line utility of the abstract database API

DESCRIPTION

       The command `tcamgr' is a utility for test and debugging of the abstract database API and its applications.  `name' specifies the name of a
       database.  `key' specifies the key of a record.	`value' specifies the value of	a  record.   `params'  specifies  the  tuning  parameters.
       `func'  specifies  the  name  of  a function.  `arg' specifies the arguments of the function.  `dest' specifies the path of the destination
       file.

	      tcamgr create name
		     Create a database file.
	      tcamgr inform name
		     Print miscellaneous information to the standard output.
	      tcamgr put [-sx] [-sep chr] [-dk|-dc|-dai|-dad] name key value
		     Store a record.
	      tcamgr out [-sx] [-sep chr] name key
		     Remove a record.
	      tcamgr get [-sx] [-sep chr] [-px] [-pz] name key
		     Print the value of a record.
	      tcamgr list [-sep chr] [-m num] [-pv] [-px] [-fm str] name
		     Print keys of all records, separated by line feeds.
	      tcamgr optimize name params
		     Optimize a database file.
	      tcamgr misc [-sx] [-sep chr] [-px] name func [arg...]
		     Call a versatile function for miscellaneous operations.
	      tcamgr map [-fm str] name dest
		     Map records into another B+ tree database.
	      tcamgr version
		     Print the version information of Tokyo Cabinet.

       Options feature the following.

	      -sx : the input data is evaluated as a hexadecimal data string.
	      -sep chr : specify the separator of the input data.
	      -dk : use the function `tcadbputkeep' instead of `tcadbput'.
	      -dc : use the function `tcadbputcat' instead of `tcadbput'.
	      -dai : use the function `tcadbaddint' instead of `tcadbput'.
	      -dad : use the function `tcadbadddouble' instead of `tcadbput'.
	      -px : the output data is converted into a hexadecimal data string.
	      -pz : do not append line feed at the end of the output.
	      -m num : specify the maximum number of the output.
	      -pv : print values of records also.
	      -fm str : specify the prefix of keys.

       This command returns 0 on success, another on failure.

SEE ALSO

       tcatest(1), tcamttest(1), tcadb(3), tokyocabinet(3)

Man Page							    2011-02-12								TCATEST(1)
All times are GMT -4. The time now is 12:53 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy