Oracle

sreepadasharma · #1 (**permalink**) 12-13-03, 00:54

HAI,
i am working with a new database which is already designed.it is very large and difficult to understand. my problem is...
can i find a perticular column in the table where it exists?
Ex.
to find emp_id column in the database which contains all the tables.
thanks..

Bart71 · #2 (**permalink**) 12-13-03, 03:28

select * from all_tab_columns where column_name = 'EMP_ID';

sreepadasharma · #3 (**permalink**) 12-13-03, 04:15

Quote:

Originally posted by Bart71
select * from all_tab_columns where column_name = 'EMP_ID';

THANK YOU SIR.BYE..

sreepadasharma · #4 (**permalink**) 12-15-03, 07:19

Quote:

Originally posted by Bart71
select * from all_tab_columns where column_name = 'EMP_ID';

HELLO SIR,
i need to contact you once again. the following query runs under ORACLE. but now i need the same resulted query which runs on SQLServer. will you please help me. once again thanks for sending the ORACLE query. waiting for your reply.
bye..

Bart71 · #5 (**permalink**) 12-15-03, 13:37

I'm sorry, i never worked with ms-sql server

Best regards

Internet Services

Web Development

Digital Marketing

Consumer Tech