sivasairam

SELECT COLUMN_NAME FROM USER_CONS_COLUMNS WHERE CONSTRAINT_NAME = (SELECT CONSTRAINT_NAME FROM ALL_CONSTRAINTS WHERE CONSTRAINT_TYPE IN ('P') AND TABLE_NAME =<TABLE_NAME>)I think this will help you...Sairam

As per my understanding ur query,I feel that this is the solution:UPDATE Student SET Student_Name= Replace(Initcap(Student_Name),'S','K') WHERE Initcap(UNIQUE_NAME) LIKE 'S%'Even without the where clause it will work...But to increase the readability , i have added it

I got it,It is select * from user_tab_cols where column_name = 'TRANSTYPE'

Hi Friends, I know the particular columnname(Eg:TRANSTYPE) but don't know the table name, Is there any SQL command by which we can find all the tables which contain this column(Eg:TRANSTYPE) sairam