07-05-2010
Quote:
Originally Posted by
panyam
There is no error, it's the normal behaviour.
If you don't want to get anything other the "ORA-....", in case of oracle shutdown , check the "SET " options in sqlplus , to turn off the sql appearing in the output.
Hi Panyam
I don't understand how this could be normal behaviour - I've not specified anywhere in the script that I want the contents of the dir to be printed.
Unfortunately, I'm unable to format the output using the SET functionality in sqlplus as I'm not just looking for ORA codes but other statuses like 'READ WRITE', MOUNTED etc.
I was hoping this would be a straightforward one!!
10 More Discussions You Might Find Interesting
1. AIX
i am trying to convert .ksh script to .bat in windows box , it says awk is not recognized as internal or external command.
this is the sample .ksh script , even if i change awk to gawk it does not work its giving me syntax error, at line one ---- it's pointing ":" and "fund:"
some one plzz help.... (0 Replies)
Discussion started by: 2.5lt V8
0 Replies
2. Shell Programming and Scripting
My requirement is to create a KSH to generate the SQL select statement in oracle with all the columns and optional where condition if given the table name as input to the program
Have any of you worked with a similar requirement? Can you give me some inputs?
Regards,
Kousikan (2 Replies)
Discussion started by: kousikan
2 Replies
3. Shell Programming and Scripting
Hi all,
I have a script which takes in sqlfile as argument and executes the sql
execSqlFile()
{
sqlFile=$1
sqlplus -S $DBLOG/$DBPWD@$DBSVR < $sqlFile
}
This works fine if the sql file is plain, simple and pre-defined statment. But i want to have a sql file which itself... (2 Replies)
Discussion started by: jakSun8
2 Replies
4. Shell Programming and Scripting
hi,
iam new of unix.
how to call sql script in ksh script (1 Reply)
Discussion started by: naveeng.81
1 Replies
5. Shell Programming and Scripting
Hi,
I need confirmation whether the same functionality exists when running the sql's.
For ex. let us consider there exists a sql file with name june.When running in sql mode does:
@june.sql and start june.sql does the same functionality.
Someone help me.
Thanks
Ashok. (1 Reply)
Discussion started by: Ashok_oct22
1 Replies
6. Shell Programming and Scripting
I am trying to create a script to manipulate numerous file and at first I thought it would be a simple task but at this point i am ready to break my computer! I am new to unix scripting so hopefully someone out there thinks this is super easy and can help me out!
A sample of the problem file is... (2 Replies)
Discussion started by: theqcup
2 Replies
7. Shell Programming and Scripting
I got a task to do today, I want to write a script for the following
1) Archive log more than 2 days old
2) Number of days the current Archive logs present
3) Total number of archive logs
4) Size of each archive log
5) When was last successful backup happened?
Can I get a general script... (8 Replies)
Discussion started by: Rambo
8 Replies
8. Shell Programming and Scripting
Hi ,
I have a txt file with contents like:
1234
2345
3456
7891
I need to write a script which takes input file as txt file..run a sql query for that number and place the output of query in another file..
select * from bus_event where acct_nbr='1234'( from input txt file)
the query... (20 Replies)
Discussion started by: Rajesh Putnala
20 Replies
9. Programming
SQL> select
2 distinct qc_m|| ',' ||
3 to_char(logon_dt, 'YYYY-MM-DD HH24:MI:SS')|| ',' ||
4 CASE WHEN logon_dt IS NOT NULL THEN 'LOGON' ELSE 'LOGOFF' END
5 from qc_ct2 qc left join v_tls_equipment_logon tls on qc.qc_m=tls.equipment_id where
6 qc.terminal_c='T'and... (1 Reply)
Discussion started by: ment0smintz
1 Replies
10. Shell Programming and Scripting
Hi
i need code to get sql queries through a shell script for a text file input which contain the service ids
iputfile
I-H-2048-10GB-M
I-H-4096-12GB-M
I-H-2048-p1000-M
the code should contain below queries among which service_id is replacable with value from input file.
... (4 Replies)
Discussion started by: surender reddy
4 Replies
LEARN ABOUT FREEBSD
start_transaction
START
TRANSACTION(7) SQL Commands START TRANSACTION(7)
NAME
START TRANSACTION - start a transaction block
SYNOPSIS
START TRANSACTION [ transaction_mode [, ...] ]
where transaction_mode is one of:
ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
READ WRITE | READ ONLY
DESCRIPTION
This command begins a new transaction block. If the isolation level or read/write mode is specified, the new transaction has those charac-
teristics, as if SET TRANSACTION [set_transaction(7)] was executed. This is the same as the BEGIN [begin(7)] command.
PARAMETERS
Refer to SET TRANSACTION [set_transaction(7)] for information on the meaning of the parameters to this statement.
COMPATIBILITY
In the standard, it is not necessary to issue START TRANSACTION to start a transaction block: any SQL command implicitly begins a block.
PostgreSQL's behavior can be seen as implicitly issuing a COMMIT after each command that does not follow START TRANSACTION (or BEGIN), and
it is therefore often called ``autocommit''. Other relational database systems might offer an autocommit feature as a convenience.
The SQL standard requires commas between successive transaction_modes, but for historical reasons PostgreSQL allows the commas to be omit-
ted.
See also the compatibility section of SET TRANSACTION [set_transaction(7)].
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)], SAVEPOINT [savepoint(7)], SET TRANSACTION [set_transaction(7)]
SQL - Language Statements 2010-05-14 START TRANSACTION(7)