What is query based database tuning?

What is Citrus Call?

What parameter must be set in init.ora file for utl_file package?

What are the virtual tables used in Oracle?

Explain how to retrive index values in Oracle SQL?

How to transfer files from SQL Server to Oracle

How to call/run a report inside another report ?

How to drag a field from one position to another during runtime in forms 6i?

Why do we disable primary key before exporting? Give Reason

How is set theory linked to DBMS (Union, intersection, minus, logical)

What is Subscription module in telecom billing project ?

Can SYSTEM.CURRENT_BLOCK value be changed. If yes how? If no Why? Give with example

This is odd and I fear I may be missing something basic. I am using the Oracle forms supplied pop up calendar widget. When I click on the calendar to select a date it returns a strange value. The year component of the date returned is in the format of '0000'. For example, If I selected today's date in the calendar it would return '0008' as the year, not '2008'. I've checked every formatting source...

How to set NLS_DATE_FORMAT for a database permanentlyfor example let's say I want to set : NLS_DATE_FORMAT= 'dd:mon:yyyy hh24:mi:ss' for the database and I am not supposed to give the ALTER SESSION command at every statrtup of the database.Plz try it practically and give me a solution