Checking Encrypted Columns of an Individual Table

You use the DESC (for DESCRIBE) statement in SQL*Plus to check the encrypted columns in a database table.

To check the encrypted columns of an individual table: 

• In SQL*Plus, run the DESC statement using the following syntax.

  DESC tablename;
  

  For example:

  DESC OE.ORDER_ITEMS;
  

  A description of the table schema appears. For example:

  Name                                      Null?     Type
  ----------------------------------------  --------  --------------------------
  ORDER_ID                                  NOT NULL  NUMBER(12)
  LINE_ITEM_ID                              NOT NULL  NUMBER(3)
  PRODUCT_ID                                NOT NULL  NUMBER(6)
  UNIT_PRICE                                          NUMBER(8,2)
  QUANTITY                                            NUMBER(8) ENCRYPT