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

Get rid of quotes signs ' with Oracle 10g and 11g

Hi,

Recently i have posted this topic on my blog with Oracle 10 and 11g you can avoid the use of additional quotes signs when creating any Literal string ...

Like in reports it is common for us to write something similar to this

e.g  ' where hiredate between '||''''||p_from_date||''''||' and '||''''||p_to_date||''''

Click here for more info 

Now u can follow me on Twitter as well 

Have a nice day,
Baig
http://baigsorcl.blogspot.com/

How to Store & Retrieve Images / Word / Excel / PDF and Movies in Oracle Database using Forms10g

Hi all,

Find out How to Store & Retrieve Images / Word / Excel / PDF and Movies in Oracle Database using Forms10g

I have uploaded working example as well

Have a nice day,

Baig

LOG LOG LOG....

 Hi all,

Well this is my first post for ORIXoom blog and i am going to advice all my peers that in your all tables specially the masters tables always give following columns

CREATED_BY .......The User who created the record
CREATED_DATE ......Date of Record creation
MODIFIED_BY......Last User who modified the record.
MODIFIED_DATE......Last date of modification in the record.

And if you can afford then always try to log deleted records in a log table. May be provide option of Logical deletion in tables for example table structure similar to this

e.g
Emp_Cd number,
Ename Varchar2(120 Char),
record_is_delete varchar2(1) defaults to N which means Record is active in database........stores Y when record is no longer needed.....

believe it or not this would definitely save u from trouble some day.

Dont forget to visit my personal blog also

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