How to set the date display format for PL/SQL

Joke: In entering the company for a period of time, will always meet a variety of small problems, but finally still "looking for Niang, ask Google" solution

The decision. But recently the company introduced a few new recruits, small problems a bunch of, PL/SQL connection not on the database, how to pass

After PL/SQL to find their own configuration file, how to query the date format is incorrect ....

Description: sometimes in use PL/SQL , the date is not displayed properly and the suffix band is displayed . E the format,

It needs to be converted into a normal format.

settings: tools tool      è                      option è  (Windows type)

è the SQL window, tick " Number field to_char" to

If in doubt, please leave a message ~-~

This article is from the "Wooden Monkey" blog, please be sure to keep this source http://muziyuan.blog.51cto.com/6180523/1827434

How to set the date display format for PL/SQL