|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to get the SQL CODE from a file?
Post 302533988 by tukuyomi on Sunday 26th of June 2011 09:00:57 AM
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello
#!bin/ksh
sqlplus -s system/manager < |grep '^ORA' |uniq
select * from kk;
set echo on
show spool on
end;
/
EOF
save test.sh
sh test.sh
results
ORA-00942: table or view does not exist (3 Replies)
Discussion started by: xiamin
3 Replies
2. UNIX for Advanced & Expert Users
Hi Guys,
I was just wondering if anybody can help me with this problem.
OK, how we can get a value back from PL/SQL Script (not stored procedure/function)
See the below example: (for example aaa.sh)
#!/bin/ksh
VALUE=`sqlplus -s user/password@test_id <<EOF
@xxx.sq
EOF`
echo $VALUE
... (7 Replies)
Discussion started by: Shaz
7 Replies
3. Shell Programming and Scripting
Hello again... I have a request from another department to list for them all the columns and tables we use in this certain database. I have spooled the oracle stored procedured into 1 file. I need a way to write out parts of that file. The criteria is to to start the block to be written when... (0 Replies)
Discussion started by: kburrows
0 Replies
4. Shell Programming and Scripting
Hi,
Iam new to unix. Is there any way to get the sql code "ORA-01847" into a variable.
sqlplus username/password@database name << EOF
set heading off
update TempTable set variable where condition;
exit sql.sqlcode;
commit;
exit;
EOF
Output
ERROR at line 1:
ORA-01847: day of... (1 Reply)
Discussion started by: manneni prakash
1 Replies
5. UNIX for Dummies Questions & Answers
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
6. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
7. Shell Programming and Scripting
Hi expert,
I have a script which is connecting with sql internally, fetch same data, store it in a file and then from os I cat this file and sending it to mail (windows outlook).
This is working fine, I just need to know wether we can add some html codes with the sql query like we can add... (0 Replies)
Discussion started by: mcagaurav
0 Replies
8. UNIX for Advanced & Expert Users
Dear all,
How to make sqlplus command to exit with an apt error code in bash script,
It always returns 0 for me.
Thanks (9 Replies)
Discussion started by: vetrivendhan
9 Replies
9. Shell Programming and Scripting
We want to check where our programmers are using lowercase SQL reserved words, ie "select" instead of "SELECT".
Obviously, we should not raise a warning for code which is commented out with "//".
Suppose I have this input:
select * from mytable
SELECT * from mytable
// select * from mytable... (2 Replies)
Discussion started by: figaro
2 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 DEBIAN
sql::reservedwords::sybase
SQL::ReservedWords::Sybase(3pm) User Contributed Perl Documentation SQL::ReservedWords::Sybase(3pm) NAME
SQL::ReservedWords::Sybase - Reserved SQL words by Sybase SYNOPSIS
if ( SQL::ReservedWords::Sybase->is_reserved( $word ) ) { print "$word is a reserved Sybase word!"; } DESCRIPTION
Determine if words are reserved by Sybase. METHODS
is_reserved( $word ) Returns a boolean indicating if $word is reserved by either Sybase ASE 12 or 15. is_reserved_by_ase12( $word ) Returns a boolean indicating if $word is reserved by Sybase ASE 12. is_reserved_by_ase15( $word ) Returns a boolean indicating if $word is reserved by Sybase ASE 15. reserved_by( $word ) Returns a list with Sybase versions that reserves $word. words Returns a list with all reserved words. EXPORTS
Nothing by default. Following subroutines can be exported: is_reserved is_reserved_by_ase12 is_reserved_by_ase15 reserved_by words SEE ALSO
SQL::ReservedWords <http://infocenter.sybase.com/help/> AUTHOR
Christian Hansen "chansen@cpan.org" COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.8.8 2008-03-28 SQL::ReservedWords::Sybase(3pm)