|
|
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 DEBIAN
sql::reservedwords::sqlite
SQL::ReservedWords::SQLite(3pm) User Contributed Perl Documentation SQL::ReservedWords::SQLite(3pm) NAME
SQL::ReservedWords::SQLite - Reserved SQL words by SQLite SYNOPSIS
if ( SQL::ReservedWords::SQLite->is_reserved( $word ) ) { print "$word is a reserved SQLite word!"; } DESCRIPTION
Determine if words are reserved by SQLite. METHODS
is_reserved( $word ) Returns a boolean indicating if $word is reserved by either SQLite 2 or 3. is_reserved_by_sqlite2( $word ) Returns a boolean indicating if $word is reserved by SQLite 2. is_reserved_by_sqlite3( $word ) Returns a boolean indicating if $word is reserved by SQLite 3. reserved_by( $word ) Returns a list with SQLite 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_sqlite2 is_reserved_by_sqlite3 reserved_by words SEE ALSO
SQL::ReservedWords <http://www.sqlite.org/docs.html> 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::SQLite(3pm)