How to view the character set of table columns in Oracle?

One way to query the character set of columns in an Oracle table is by using the `DESC` command to check the table structure and view the character set of the columns. For example:

  DESC table_name;

In the results, you can view the data type and character set of each column. Use the `ALL_TAB_COLUMNS` view to query the column information of a table, including the character set. For example:

  SELECT column_name, data_type, data_length, character_set_name
  FROM all_tab_columns
  WHERE table_name = 'your_table_name';

This will retrieve the names, data types, data lengths, and character sets of each column in the table. Use the `USER_TAB_COLUMNS` view to query information about the columns of tables owned by the current user, including character sets. For example:

  SELECT column_name, data_type, data_length, character_set_name
  FROM user_tab_columns
  WHERE table_name = 'your_table_name';

This will return the names, data types, data lengths, and character sets of each column owned by the current user.