The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Advanced & Expert Users
.
google unix.com




Thread: grep problem
View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 07-21-2008
infyanurag infyanurag is offline
Registered User
  
 

Join Date: Nov 2007
Posts: 65
grep problem

SQL*Plus: Release 9.2.0.8.0 - Production on Mon Jul 21 07:53:35 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production

SQL> SQL> USER is "CCOD"
SQL> cREATE TABLE HELLOEVERY (DEF VARCHAR2(40))
*
ERROR at line 1:
ORA-00955: name is already used by an existing object


SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production
SQL*Plus: Release 9.2.0.8.0 - Production on Mon Jul 21 07:53:35 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production

SQL> SQL> USER is "CCOD"
SQL> cREATE TABLE greatwork(abcVARCHAR2(40))
*
ERROR at line 1:
ORA-00955: name is already used by an existing object


SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production


i just want to have
SQL> cREATE TABLE HELLOEVERY (DEF VARCHAR2(40))
*
ERROR at line 1:
ORA-00955: name is already used by an existing object

SQL> cREATE TABLE greatwork(abcVARCHAR2(40))
*
ERROR at line 1:
ORA-00955: name is already used by an existing object


there could be repeated pattern as well.

is there any way to grep only 3 or 4 lines after grepping a pattern

please help

thanks