Lets have look @ what we have in Oracle apex 4.1 .............
wokay lets gooo :)
The first change is Oracle apex Help link ... :(
1) It no more points to the PDF developer guide on our local instance ...it takes us to apex.oracle.com guide :( , now incase i m working offline then i cannot access the Help link :( ( Huh)
2) The Sample application link had more no of smaple applications with examples sqon collections , database application and websheet application even :D
3) The learn more link of Oracle APEX points to the link , which opens another application , which is a websheet apex application , hence giving us gud idea how best we can use our websheet applications .
4) Web sheet application were simply a static pages with no dynamic data , but i found that 4.1 allows us to integrate the sql queries in the websheet . Along with this it even has come up with concept of data grid ... ( i remebred i encountered this term when i was doing by 12th and was working on Visual basic , data grid is nothing but a drag and drop tool , where we can enter certain data in form of excel and then perform basic db operations , i guess it will create the respective table :D... though i didnot cross check as there was no developer edit option in Websheet :( huh.
The demonstration section of the learning area is quite interesting and gives us amazing confidence of what all is possible in apex , i remebered in one my assignments i was struggling with the
" Hierarchy example" and here oracle apex 4.1 comes with the solution itself :D grt to know that :D .
XML example is very very interesting ... it teaches you how to play with XML data :D.
Dashboard region is an excellent Example of the Dynamic content .
Seriously i m dam excited to dirty my hands on this examples :D .. you will even love it for sure ;)
Again Forms examply thats Data entry in the tutorial list , it just gave a simple example to come out with the old look n fell of form and give a very refreshing look of jquery .
Go thru even Oracle maps and other example even .
5) In a case , you have to upgarde you application suppose changing names of the items and lablels and all ... then now its made easier , who donot have to navigate each time to different pages to look for item .
You have something called utilities @ apex 4.1 @ application level even , in the right side you can see page utitlites , region utilties , item utilties , you can see all corresponding objects and change them here , rather than struggling and navigating to diff pages. You can edit all othem labels , help text and subsriptions in one go :)
6)My fav one is Methods on Tables Utility
Home > SQL workshop > Utility > Methods on tables.
This uitilty will create an API for you on a table .
U need to input table name and it will create package containing all possible dml operations on tables with select_operation ( called get_tablename ) procedure .
The most best part was it was using md5 checksum function which most of the developers donot use to update the database . This will avoid data integirty .
-- build MD5 function for table "AGENDA"
function "BUILD_AGENDA_MD5" (
"P_AGENDA_ID" in number,
"P_MEETING_ID" in number,
"P_SELECT_AREA" in varchar2 default null,
"P_AGENDA_ITEM" in varchar2 default null,
"P_DATE_TODAY" in date default null,
"P_COL_SEP" in varchar2 default '|'
) return varchar2 is
begin
return utl_raw.cast_to_raw(dbms_obfuscation_toolkit.md5(input_string=>
"P_MEETING_ID" ||"P_COL_SEP"||
"P_SELECT_AREA" ||"P_COL_SEP"||
"P_AGENDA_ITEM" ||"P_COL_SEP"||
"P_DATE_TODAY" ||"P_COL_SEP"||
''
));
wokay lets gooo :)
The first change is Oracle apex Help link ... :(
1) It no more points to the PDF developer guide on our local instance ...it takes us to apex.oracle.com guide :( , now incase i m working offline then i cannot access the Help link :( ( Huh)
2) The Sample application link had more no of smaple applications with examples sqon collections , database application and websheet application even :D
3) The learn more link of Oracle APEX points to the link , which opens another application , which is a websheet apex application , hence giving us gud idea how best we can use our websheet applications .
4) Web sheet application were simply a static pages with no dynamic data , but i found that 4.1 allows us to integrate the sql queries in the websheet . Along with this it even has come up with concept of data grid ... ( i remebred i encountered this term when i was doing by 12th and was working on Visual basic , data grid is nothing but a drag and drop tool , where we can enter certain data in form of excel and then perform basic db operations , i guess it will create the respective table :D... though i didnot cross check as there was no developer edit option in Websheet :( huh.
The demonstration section of the learning area is quite interesting and gives us amazing confidence of what all is possible in apex , i remebered in one my assignments i was struggling with the
" Hierarchy example" and here oracle apex 4.1 comes with the solution itself :D grt to know that :D .
XML example is very very interesting ... it teaches you how to play with XML data :D.
Dashboard region is an excellent Example of the Dynamic content .
Seriously i m dam excited to dirty my hands on this examples :D .. you will even love it for sure ;)
Again Forms examply thats Data entry in the tutorial list , it just gave a simple example to come out with the old look n fell of form and give a very refreshing look of jquery .
Go thru even Oracle maps and other example even .
5) In a case , you have to upgarde you application suppose changing names of the items and lablels and all ... then now its made easier , who donot have to navigate each time to different pages to look for item .
You have something called utilities @ apex 4.1 @ application level even , in the right side you can see page utitlites , region utilties , item utilties , you can see all corresponding objects and change them here , rather than struggling and navigating to diff pages. You can edit all othem labels , help text and subsriptions in one go :)
6)My fav one is Methods on Tables Utility
Home > SQL workshop > Utility > Methods on tables.
This uitilty will create an API for you on a table .
U need to input table name and it will create package containing all possible dml operations on tables with select_operation ( called get_tablename ) procedure .
The most best part was it was using md5 checksum function which most of the developers donot use to update the database . This will avoid data integirty .
-- build MD5 function for table "AGENDA"
function "BUILD_AGENDA_MD5" (
"P_AGENDA_ID" in number,
"P_MEETING_ID" in number,
"P_SELECT_AREA" in varchar2 default null,
"P_AGENDA_ITEM" in varchar2 default null,
"P_DATE_TODAY" in date default null,
"P_COL_SEP" in varchar2 default '|'
) return varchar2 is
begin
return utl_raw.cast_to_raw(dbms_obfuscation_toolkit.md5(input_string=>
"P_MEETING_ID" ||"P_COL_SEP"||
"P_SELECT_AREA" ||"P_COL_SEP"||
"P_AGENDA_ITEM" ||"P_COL_SEP"||
"P_DATE_TODAY" ||"P_COL_SEP"||
''
));
