Sunday, June 24, 2007

Oracle plsql building blocks

Pl/Sql is the programming language of ORACLE rdbms, This language is found to be useful by
DB programmers from the begining . It is prefered to write business logic in plsql for performance ressions . for Detail help regarding ORACLE inbuilt functions & packages visit following link


ORACLE inbuilt functions

http://www.psoug.org/reference/builtin_functions.html


here all functions are mentioned with link to detail explanation as per their datatype on which they affect.

ORACLE inbuilt packages

http://www.psoug.org/reference/builtin_packages.html

here some dbms package are mentioned with examples

New face of oracle ADF

JSF - a New View on Oracle ADF

In its efforts of trying to make J2EE simpler, Oracle has been providing J2EE best practices, such as design patterns and application infrastructure in a framework it calls ADF (Application Development Framework). What is really interesting with ADF is that it is platform independent, as it will run on any J2EE compliant application server. Better yet, it provides options for every J2EE layer and development life-cycle phase, and you can use anyone you like. You are not forced to use all or nothing.

Oracle ADF is based on the Model-View-Controller (MVC) design pattern. View layer, which provides the user interface of an application. The view layer uses various markup languages to render the user interface, and it can be web-based, client/server based, a wireless implementation, or even telnet based. The focus is specifically on JavaServer Faces (JSF). Faces, as it's also known, not only provides a view layer, but also a navigation capability, similar to that of Struts and what is called backend beans or managed beans, where you can put your business logic and the interaction with the data sources. With that alone you could start building applications, as Faces is an MVC framework in its own.