Category: Database

Default display format for date field in Oracle SQL Developer

For date fields, by default SQL Developer will display data in date only without the time. To set it to display the time as well, do the following: 1. From SQL Developer, open menu Tools >> Preferences. 2. From the Preferences dialog, select Database >> NLS Parameters from the left panel. 3. From the list […]

Tuesday November 18th, 2008 in Database, Learning in progress | 4 Comments »

Revisit to Entity Relationship Diagram (ERD)

While evaluating the diagramming tools for NetCom project, I just realize that I had forgot a lot of things which I learnt long time ago. This is a good chance for me to refresh my knowledge on ERD. I use Dia, one of the tools being evaluated, for drawing various common ERD notations together with […]

Saturday September 20th, 2008 in Database, Learning in progress | 2 Comments »