Tag: Oracle system tables

• 3 Mar 2009

  SYS_CONTEXT Function

  These days I am working on a project in which there was a requirement to track the User. The tracking was to be done at two levels: First the User Id with which the user logs in into the VB(Visual Basic) application (this is easy, from the Login Screen) and secondly the actual user id…
• 18 Feb 2009

  PL/SQL -> Finding a column name in all tables

  The other day, while working on a project I needed to find all the tables in a schema with a particular column name. Say for example, I wanted to list all the tables having a column name ’empid’. Following is the Oracle query to do just the same. select a.table_name, column_name,DATA_TYPE,DATA_LENGTH from all_tab_columns a,USER_ALL_TABLES u…