Results 1 to 5 of 5

Thread: Oracle

  1. #1
    Join Date
    Nov 2003
    Location
    hyderabad
    Posts
    12

    Unanswered: Oracle

    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..

  2. #2
    Join Date
    Oct 2003
    Location
    Germany - Stuttgart
    Posts
    14
    select * from all_tab_columns where column_name = 'EMP_ID';

  3. #3
    Join Date
    Nov 2003
    Location
    hyderabad
    Posts
    12
    Originally posted by Bart71
    select * from all_tab_columns where column_name = 'EMP_ID';
    THANK YOU SIR.BYE..

  4. #4
    Join Date
    Nov 2003
    Location
    hyderabad
    Posts
    12

    ORACLE

    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..

  5. #5
    Join Date
    Oct 2003
    Location
    Germany - Stuttgart
    Posts
    14
    I'm sorry, i never worked with ms-sql server

    Best regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •