|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Spotting lowercase SQL code
Post 302610737 by figaro on Wednesday 21st of March 2012 05:38:57 PM
03-21-2012
|
|
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. Shell Programming and Scripting
Greetings & Happy New Years To All!
A client of mine FTP'ed their files up to the server and it all ended up being in UPPERCASE when it all should be in lowercase. Is there a builtin command or a script anyone knows of that will automagically convert all files to lowercase?
Please advise asap... (4 Replies)
Discussion started by: webex
4 Replies
3. 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
4. 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
5. 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
6. 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
7. Shell Programming and Scripting
Hi Guys :)
need your help once again
I have some files from which I have to fetch the SQL CODE which in anywhere in file. please help me
input files : file1 :
ERROR ON SECTION : 2060-GET-OTHER-DEP-INFO
ERR MSG : ERROR IN FETCH MCURS
SQL CD : 100 SUBS ID : 153687143
input... (5 Replies)
Discussion started by: atul9806
5 Replies
8. Shell Programming and Scripting
Hello,
I have a list of files in a directory whose names are all in uppercasse, including the file format for eg *.MP3 . I would like to convert these to the normal way we write it ie ABC.MP3 to be converted to Abc.mp3 . I know that this can be done manually by using a lot of "mv" or rename... (6 Replies)
Discussion started by: ajayram
6 Replies
9. 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
10. What is on Your Mind?
Spotting Aggressive Clandestine BotNets
"Yesterday was making a typical “evening run” in cyberspace and noticed a strange pattern, zoomed in, and found a aggressive clandestine “indexing” botnet operating out of a dedicated hosting provider’s datacenter. The feature image in this post shows a... (0 Replies)
Discussion started by: Neo
0 Replies
LEARN ABOUT XFREE86
zgrep
ZGREP(1) General Commands Manual ZGREP(1) NAME
zgrep - search possibly compressed files for a regular expression SYNOPSIS
zgrep [ grep_options ] [ -e ] pattern filename... DESCRIPTION
Zgrep invokes grep on compressed or gzipped files. These grep options will cause zgrep to terminate with an error code: (-[drRzZ]|--di*|--exc*|--inc*|--rec*|--nu*). All other options specified are passed directly to grep. If no file is specified, then the standard input is decompressed if necessary and fed to grep. Otherwise the given files are uncompressed if necessary and fed to grep. If the GREP environment variable is set, zgrep uses it as the grep program to be invoked. EXIT CODE
2 - An option that is not supported was specified. AUTHOR
Charles Levert (charles@comm.polymtl.ca) SEE ALSO
grep(1), gzexe(1), gzip(1), zdiff(1), zforce(1), zmore(1), znew(1) ZGREP(1)