Search results for query: *

Hi , We have a standard Solaris installation so no "i" option for case insensitive sed. I have a lot of oracle views in which I need to replace the table names with different tablenames. There is one script per view. So the set of oracle scripts is like V_123.sql , V_ABC.sql , V_DEF.sql...

Hi, Is there a way to strip off the last few characters of a string. ( In my example, I need to stroip the last 4 characters) So the example input strings are 2276680000EUR201020971 2338810000EUR201021861 And the output I need is 2276680000EUR20102 2338810000EUR20102 I couldnt see any...

Hi I have a file which has things like CREATE TABLE .... ... ; ; CREATE TABLE ... ; CREATE TABLE ... ; ; CREATE TABLE ... / CREATE TABLE ... / ; I need to find out the occurances of semi colon followed by nothing then a semicolon. Is there a way to do it in some kind of a awk...

Hi , I have a SQL file with a set of CREATE OR REPALCE statements. There are always two sets for every object created. I need the first occurance of each of these statements... Like for example... #my_orig_file.sql CREATE OR REPLACE view test1 as select sysdate from dual; CREATE OR REPLACE...

Hi, I need to do something like for i `ls -1 *.sql ` do for k in `grep "MY TEXT" $j ` do .. ... .. done done And one of the sql files may contain lines like MY TEXT ABC fkjgnhdfg MY TEXT PQR dfkljgn MY TEXT XYZ So a grep would return three lines and I want to work on the three...

I have a text file with which, besides other things contains lines like ADD CONSTRAINT ADRA_UK UNIQUE (ADRA_ADRA_ADRACD, ADRA_MND_MNDCD) ... ... ADD CONSTRAINT ADR_ADRA_FK FOREIGN KEY (ADR_ADRA_AACD, ADR_MND_MNDCD) ... ... CREATE INDEX ADR_ADRA_FK ON ADRESSE$ (ADR_ADRA_AACD...

Hi , I have a huge file with a lot of oracle statements. In there is there a way to do the following When I come across the text "_OLD_FK" like below lines ALTER TABLE TEST$AB DROP CONSTRAINT TEST_OLD_FK / I need to add another set of lines with the _OLD_FK replaced with _NEW_FK so the...

Hi, I have a number of sql scripts and within those scripts I need to comment out certain sections. So, if the file is like below text... text... text... Insert into table ....( ) values ( ...) / commit / text... text.. I need to start commenting out the lines where the first word is...

Hi, I guess it must be possible to pass in named parametrs, but I dont know how. I know that you could read parameters by saying $1, $2, $3...etc., but the users want to pass in values in any order, but they will say like $run_my_script.ksh PERCENT=10 NAME=JANE OR $run_my_script.ksh...

Hi, I have a file like BINDS #17: bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=00 oacfl2=1 size=352 offset=0 bfp=ffffffff7d05fa48 bln=22 avl=02 flg=05 value=18 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=00 oacfl2=1 size=0 offset=24 bfp=ffffffff7d05fa60 bln=22...

Hi, This is my first instance of doing a script on Windows for connecting to an oracle database. I have only used Unix all this while. So has anyone got an idea of how can I do something, similar as below, on a windows platform from the command prompt. On UNIX I would do --------------...

Hi, I am an Oracle developer. I need to build a web interface to the database using Java. Now I have never worked with Java but since that is the preferred technology adapted by my organization I need to follow it. I have absolutely no idea as to where to start, I have read a few books on...

Hi, Is there a way to write a script which reads line by line fromtwo different files, compares the two inputs and reports if there are different. Thanks.

Hi , I have a file with data like FamilyP: : ChildD : ChildC : ChildA FamilyD: : ChildC : ChildB FamilyA: : ChildP : ChildB Is there a way in which I could sort the data so that it is sorted by family and children. I tried the sort command but...

Am getting a /sbcimp/run/pd/cpan/5.8.2-2004.01/lib/auto/Crypt/SSLeay/SSLeay.so: symbol Perl_Gthr_key_ptr: Referenced symbol not found. Any ideas as to why this is. I am using perl 5.8.7 TIA

#!/sbcimp/run/pd/perl/5.6.1/bin/perl use lib '/sbcimp/run/pd/cpan/5.6.1-2001.06/lib'; use LWP; use HTTP::Request; use URI; $ua = LWP::UserAgent->new; $ua->proxy('http' => 'http://myproxy:8080'); $req = HTTP::Request->new('GET','http://www.google.com')...

Hi , Have an XML file a section of which is as below <component> <refentity> <name>ABITIBI-CONSOLIDATED INC.</name> <red>003CB6</red> </refentity> <bond> <name>ABY 8.55 01Aug10</name> <issuer>...

I m sure peopel have answered this before, but I couldnt find a answer , so How can I delete a blank line from a data file using awk Many thanks

<?xml version="1.0"?> <data> <header> <name>Red Obligation Download 2</name> <version>1.1a</version> <date>2004-08-03</date> </header> <bond> <name>NBR-Inc 0 05Feb21</name> <issuer>...

Hi, I m working on a Oracle 9.2 db. I need to load an xml file onto a table using sql*Loader. Any ideas how I could do this. Or are there any other ways to do it which do not involve Java or other scripting languages. Thanks,