Anyone help me to solve this problem plz.
i have a table contain below fields
Geo = GREGORIAN
i want to do this following when when ever i call this form is should set the nls_calender to arabic hijrah in pre_form trigger if im not wrong i can use the below code?
and when user enter date in hijri_isu_date and hijri_exp_date it will convert to gregorian date automatically according to hijri date as per user entered.
forms_ddl('alter session set nls_calendar=''Arabic Hijrah''');
anyone explain me please how can i do this convertion?