search a string

• chinni-652949

  Default port

  Points: 1425

  More actions

  April 7, 2008 at 9:13 am

  #188781

  need to search for a string

  for ex. tablename_ref.hello

  i need to find hello from columns in a table and also i have some columns like

  tablename.hello1 in same table

  i need to bring hello ,hello1 into two temp tables............

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  April 7, 2008 at 9:45 am

  #799257

  I cannot understand your post entirely, but I think you are looking for the information_schema.columns view

• chinni-652949

  Default port

  Points: 1425

  More actions

  April 7, 2008 at 9:57 am

  #799259

  thanks for ur response..

  i need to search for a column names which are present in a table in the below format..

  tablname_ref.ColumName1

  tablname_ref.ColumName2

  tablname.ColumName11

  tablname.ColumName22

  i need to retrieve the ColumName1 from

  tablname_ref.ColumName1

  and

  ColumName11 from

  tablname.ColumName1 and place them in two different temp tables

  the table looks like

  Objname

  tablname_ref.ColumName1

  tablname_ref.ColumName2

  tablname_ref.ColumName3

  tablname.ColumName11

  tablname.ColumName12