Show Me
 

Viewing Settings

Previous previous|next Next Page

The About Database page (under Administration) provides information about the following database settings:

  • Version
  • Database
  • Options
  • Feature usage
  • National language support
  • CGI environment

Sheila wants to view the parameter settings for the database. She then wants to change the format of the date displayed in her session to mm/dd/yy, because this is the format required for her reports. She can change this by using one of the following options:

  • ALTER SESSION command: Applies the change only to Sheila's current session

  • ALTER SYSTEM command: Keeps the setting only until the current instance of the database is shut down
  • Make the change in the initialization parameter file and then restart the database. This keeps this setting until the parameter file is edited again.

Sheila opts for the first method using the SQL command interface.

Watch Sheila view the settings information.

Launch Demonstration

Show Me and Try it