More ADF

Hi all,

More Oracle ADF's Tutorials, Tips and Trick you can find here

Regards,
ZB

Do you think you are good in PL/SQL ?

Then try this site play daily and win monthly this site is from PL/SQL guru Mr.Steven Feuerstein who works in Quest software and writes regular column in Oracle magazine as well

http://plsqlchallenge.com

Regards,
ZB

Creating Master-detail form in Oracle ADF

Hi all,

Posted new blog post How to create Master detail form in Oracle ADF using Jdeveloper 11g

Check here


Have a nice day,
ZB

Creating LOV in ADF Application

Hi,

This week i have posted how to create LOV in ADF application

Check here

Happy Learning,
ZB

Moving to Jdeveloper 11g Your First ADF Form

Hi all,

Just posted the simple tutorial how to create Simple ADF form on Jdeveloper 11g hope u guys like

Click here for more Info

Feel free to comment

Have a nice day,
ZB

How to get Date in Hijrah calendar from Oracle

Hi,

NLS_CALENDAR by default is GEORGIAN in the database so it displays date in Georgian calendar but on demand if u want HIJRI date in Calendar no worries  using To_char we can achieve this


select to_char(sysdate,'fmdd month rrrr','nls_calendar=''arabic hijrah''') from dual

select to_char(sysdate,'fmdd month rrrr','nls_calendar=''english hijrah''') from dual

Output would be like
 
18 ربيع الأول    1431
18 Rabi' Awwal  1431

If we want our database to follow HIJRI calendar then NLS_CALENDAR parameter need to be change
more info about current database settings and valid values

select * from database_properties;
select * from v$nls_parameters;
select * from v$nls_valid_values;
 This tip might helps our Middle-eastern and Saudian guys :)

Regards,
ZB
http://baigsorcl.blogspot.com/

Restore Table to Specific Point in Time without any headache

Hi,

Sometimes it happens that we wrongly commit delete or update which makes our data logically corrupt before 10g its a time consuming job to restore table to specific point in time or re-import tables from backup etc etc with 10g u can restore it without any problem using FLASHBACK TABLE feature

Click here for more info

Cheers,
ZB