01-10-2007
Quote:
Originally Posted by kakashi_jet
Hi,
Suppose I have the following text in a file.
ORA-00942: table or view does not exist
ORA-01555: snapshot too old: rollback segment number string with name "string"
too small
Is there any way I can list all the text that starts only with 'ORA-'?
Or there any grep command that can pull out only 'ORA-xxxxx'? Having X as any number.
Please help.
thanks.
hi try out this
grep "^ORA\-\[1\-9\]\{5\}" filename
10 More Discussions You Might Find Interesting
1. Programming
Hi all,
i have the following string as input :
"<iframe src="http://abcdef.com/asd/aaa/awerftya0480000008ave/direct;wi.120;hi.600/01?page=" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" topmargin="0" leftmargin="0" allowtransparency="true" width="120" height="600">
<script... (1 Reply)
Discussion started by: trinath
1 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I have a file with rows of text like so :
E100005568374098100000015667
D100005568374032000000112682
H100005228374060800000002430
I need to grab just the last digits(bolded) of each line without the proceeding text/numbers.
Thanks (5 Replies)
Discussion started by: james6
5 Replies
3. Shell Programming and Scripting
Hi,
i am just gettin exposed to UNIX.
Could anyone of u help me out with dis problem..?
i have a variable 'act' which has the value as follows,
echo $act gives -0- -0- -----0---- 2008-06-04 -0- -0-
echo "$act" | awk '{print ($act)}'
gives,
-0-
-0-
-----0----
2008-06-04
-0-
-0-
I... (2 Replies)
Discussion started by: jerrynimrod
2 Replies
4. Shell Programming and Scripting
i have a file that contains a pattern like this:
ajay 1234 newyork available
kumar 2345 denver
singh 2345 newyork
ajay 3456 denver
kumar 3456 newyork
singh 3456 delhi available
ajay 4567 miami
kumar 4567 miami
singh 4567 delhi
i want to search for each line... (5 Replies)
Discussion started by: ajay41aj
5 Replies
5. Shell Programming and Scripting
First of all I am VERY new to this so bare with me and try and explain everything even if it seems simple.
Basically I want to read a line of text from a html file. See if the line of text has a certain string in it. copy an unknown number of characters (the last 4 characters wiil be ".jpg" the... (1 Reply)
Discussion started by: c3lica
1 Replies
6. Shell Programming and Scripting
Hi,
I have a file in the following format
123|shanwer|15DEC2010|bgbh|okok|16JAN3000|okok|
I want the following to be in following format
123|shanwer|12\15\2010|bgbh|okok|01\16\3000|okok|
SED/PERL/AWK Gurus
could you please help me with this?
Thanks
Shankar (8 Replies)
Discussion started by: Shan2210
8 Replies
7. Shell Programming and Scripting
Hi All,
Pls help me out on the below,
05 LAMSZ201-ZM-MEMO2-DATE02-5 PIC X(10).
05 LAMSZ201-ZM-MEMO2-AMT02-5 PIC S9(13)V99.
05 LAMSZ201-ZM-MEMO2-TYPE02-6 PIC XXX.
05 LAMSZ201-ZM-MEMO2-DATE02-6 PIC X(10).
05 ... (2 Replies)
Discussion started by: baskivs
2 Replies
8. Shell Programming and Scripting
Hello
Could you help with small script:
How to split string X1 into 3 string
String X1 can have 1 or many strings
X1='A1:B1:C1:D1:A2:B2:C2:D2:A3:B3:C3:D3'
This is output which I want to have:
Z1='A1:B1:C1:D1'
Z2='A2:B2:C2:D2'
Z3='A3:B3:C3:D3' (5 Replies)
Discussion started by: vikus
5 Replies
9. Shell Programming and Scripting
i have something like this...
echo "teCertificateId" | awk -F'Id' '{ print $1 }' | awk -F'te' '{ print $2 }'
Certifica
the awk should remove 'te' only if it is present at the start of the string.. anywhere else it should ignore it.
expected output is
Certificate (7 Replies)
Discussion started by: vivek d r
7 Replies
10. Shell Programming and Scripting
I'm making a little game in Perl, and I am trying to remove the first instance of a character in an arbitrary string. For example, if the string is
"cupcakes"and the user enters another string that contains letters from "cupcake" e.g:
"sake"the original string will now look like this (below)... (3 Replies)
Discussion started by: whyte_rhyno
3 Replies
LEARN ABOUT PHP
oci_set_edition
OCI_SET_EDITION(3) OCI_SET_EDITION(3)
oci_set_edition - Sets the database edition
SYNOPSIS
bool oci_set_edition (string $edition)
DESCRIPTION
Sets the database "edition" of objects to be used by a subsequent connections.
Oracle Editions allow concurrent versions of applications to run using the same schema and object names. This is useful for upgrading live
systems.
Call oci_set_edition(3) before calling oci_connect(3), oci_pconnect(3) or oci_new_connect(3).
If an edition is set that is not valid in the database, connection will fail even if oci_set_edition(3) returns success.
When using persistent connections, if a connection with the requested edition setting already exists, it is reused. Otherwise, a different
persistent connection is created
PARAMETERS
o $edition
- Oracle Database edition name previously created with the SQL " CREATE EDITION" command.
NOTES
Note
Oracle version requirement
This function is available from Oracle 11 gR2 onwards.
Caution
Persistent connections
To avoid inconsistencies and unexpected errors, do not use ALTER SESSION SET EDITION to change the edition on persistent connec-
tions.
Caution
DRCP Connection Pooling
To avoid inconsistencies and unexpected errors when using editions and DRCP with Oracle 11.2.0.1, keep a one-to-one correspondence
between the oci8.connection_class and the edition name used by applications. Each pooled server of a given connection class should
only be used with one edition. This restriction has been removed with Oracle 11.2.0.2.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Two scripts can use different versions of myfunc() at the same time
<?php
// File 1
echo "Version 1 of application
";
oci_set_edition('ORA$BASE');
$c = oci_connect('hr', 'welcome', 'localhost/XE');
$s = oci_parse($c, "begin :r := myfunc(); end;");
oci_bind_by_name($s, ":r", $r, 20);
oci_execute($s);
echo "The result is $r
";
?>
<?php
// File 2
echo "Version 2 of application
";
oci_set_edition('E1');
$c = oci_connect('hr', 'welcome', 'localhost/XE');
$s = oci_parse($c, "begin :r := myfunc(); end;");
oci_bind_by_name($s, ":r", $r, 20);
oci_execute($s);
echo "The result is $r
";
?>
PHP Documentation Group OCI_SET_EDITION(3)