Sql Experts

[i_sudigadu]

oka particular string kosam entire db search cheyali ( accross all tables ,all columns  ) .

 

 

Ex : "CREDIT " ane string value vunna anni  columns across all the table ni retrive cheyali

[puli_keka]

google    search all tables and columns for value

[i_sudigadu]

google    search all tables and columns for value

 

ratledu bro ..tried ...stored procedures evo vunnayi but not working

[Suhaas]

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

[Suhaas]

aa link loni stored proc create cheyyi db lo and then you run the sp 

 

EXEC SearchAllTables 'afdb'
GO

[ceelogreen]

redgate SQL prompt/search vunte easy

[Kickuu]

Google ni Adigithe idhi Tolded.. :D :D

 

https://gallery.technet.microsoft.com/scriptcenter/c0c57332-8624-48c0-b4c3-5b31fe641c58

[venkannadora]

store proedure use cheyyakunda 

 

http://serverfault.com/questions/45684/how-to-search-an-entire-ms-sql-2005-db-for-a-value

 

[LungiLingaraju]

SQL developer vadithe lookup ani untadi binoculars symbol tho .. Andulo type chey CDREDIT ani

[RAHUL_DRAVID]

 select type, name, line, text

from all_source

where owner = 'SCHEMA NAME'

and upper(text) like '%STRING%';

[i_sudigadu]

aa link loni stored proc create cheyyi db lo and then you run the sp 

 

EXEC SearchAllTables 'afdb'
GO

 

Thanks bro ...will try
 

[arjun510]

oka particular string kosam entire db search cheyali ( accross all tables ,all columns  ) .

 

 

Ex : "CREDIT " ane string value vunna anni  columns across all the table ni retrive cheyali

not possible without a strored proc.. its the only way.

[Walcommon]

 SELECT 'PROMPT    *********** ' || UPPER(A.TABLE_NAME) ||'  *****************' || CHR(10)  || 

        'SELECT '||UPPER(A.TABLE_NAME)  || '.'|| UPPER (B.COLUMN_NAME)|| ' FROM  ' || UPPER(A.TABLE_NAME) || 

        '  WHERE  ' ||  UPPER (B.COLUMN_NAME) || '  LIKE  ' ||  '''CREDIT'''  ||  ';' 

  FROM ALL_TABLES A    , ALL_TAB_COLUMNS B

 WHERE UPPER(A.TABLE_NAME) =  UPPER(B.TABLE_NAME)

   AND UPPER(B.DATA_TYPE)  =  UPPER('VARCHAR2')

   AND UPPER(A.OWNER)      =  UPPER('Give the owner name if you have');

 

 

this Will give you all the tables ans column names.

Then keep all the individual sql's in .sql file run this file in SQLPLUS through command prompt

         

[nag]

oka particular string kosam entire db search cheyali ( accross all tables ,all columns  ) .

 

 

Ex : "CREDIT " ane string value vunna anni  columns across all the table ni retrive cheyali

 

"SQL Search"   red gate company plugin install chesuko.. its free ...  nee problem 100% solve avuthadi

[mtkr]

k