Querying the information for a field in a table

Use the SELECT statement to query the field information in the Logmnr_parameter$ table under System users.

Implementation ideas:

The information for the field of the table is queried through the data dictionary dba_tab_columns.

The query statements are as follows:

Desc Dba_tab_columns;

Select Columns_id,columns_name from Dba_tab_columns where table_name= 'logmnr_parameter$;

Note: You can see the table in the data dictionary through the first statement, and note that the name of the table needs to be capitalized in the WHERE clause.

Querying the information for a field in a table