SQL Developer: Set default date format to date and time

SQL Developer default display date field data without time:

We can set this default date format to date and time:

• Open SQL Developer, Open Menu Tools => Preferences
• From the Preferences dialog, Select option Database=> Click NLS
• NLS paremeters will display right side
• Update the "Date Format" parameter value to "DD-MON-RR HH24:MI:SS"
• Click "Ok" button to save and close the preference dialog

You have done, Now run the select statement and see the date filed values.

Display the message in the status bar - Oracle Forms

Display the message in the status bar - Oracle Forms

To display the message in the status bar in Oracle Forms below mentioned command can be used,
Message('Message you want to display',NO_ACKNOWLEDGE);

Insert %rowtype variable directly into a table

Can I insert a %rowtype variable directly into table without specifying each column?
Ans: Yes

 Normally we are putting open and closed brackets after values. Remove these brackets in the case %rowtype variable.

Syntax:
Insert into << values >><<%rowtype variable>>

eg: 

Procedure create_emp(p_emp_rec In emp%rowtype)
Is
Begin
insert into emp values p_emp_rec;
End create_emp;

The Macro Cannot be Found or Has Been Disabled (BI Publsiher)

The Macro Cannot be Found or Has Been Disabled (BI Publsiher)

 Error BI Publisher macros in Word : "The macro cannot be found or has been disabled because of your macro security settings"


Solution:
Close word application
Find out the file named MSComctlLib.exd
Backup the existing MSComctlLib.exd file
This file can be regenerated when you re-open the word.