Wednesday, September 25, 2013

OOW Notes - Some new features in SQL Developer 4.0

cursor on * brings all columns

select * from t_asset_brand;

explain plan button

explain plan brings drop down for the executed plans if the sql is executed

connection properties

connection color in the connection properties to change the border colors of the inner windows

cart option

menu -> view -> cart

drag and drop the tables to the cart window
create scripts for both ddl and dml
diff reports between carts
export cart data and ddl

advanced chart reports

you can test it before saving
while developing you can see the changes immediately

pdf exports are enhanced

allowed to generate template
allowed to add header and footer
create a detail report and generate into a secure pdf
report properties->pdf->security in order to add password protection to the pdf exports

No comments:

Post a Comment