Posts

Showing posts from August, 2011

Best Desktop Linux Distribution

Image
In the past few year Ubuntu occupy the top position in the Linux Desktop Distribution. But after the release of Fedora 15 it come out on top spot in the Linux Desktop Distribution in 2011. Some features of Fedora 15 are given below.



How to perform a character wise replacement of a string in Oracle

Image
In Oracle SQL/PL-SQL the TRANSLATE function performs a character wise replacement of a string. The syntax is: TRANSLATE( input_string , string1 , string2 )

- String1 is the string that will be searched for in input_string - All characters in the String1 will be replaced with the corresponding character in the String2.


Create Filter or Criteria List of Values (LOV) in Oracle ADF

Image
In this post i will show you how to create LOV with View Criteria. Do the following steps:-


1) Create View Object
2) Add Bind Variables to Views
3) Create View Criteria
4) Finally Create LOV


This post the enhancement of previous post and in this post we will create LOV on Manager ID field. We are going to add two business rules on Manager ID LOV:-


1) Manager cannot manage themselves i.e ( EmployeeId <> CurrentEmployeeId)
2) Employee can be manage by other employees in the same department or in Executive Department which ID is 1. (DepartmentId = 1 OR (DepartmentId = CurrentDepartmentId))


Creating View Object


Right click on adf.demo.modle.quries package and select New View Object



Create List of Values - LOV in Oracle ADF

Image
In this post i will continue to enhance my previous post's Employee Form and create my first List of Values (LOV) in Oracle ADF Form. Creation of LOV in ADF is as simple as in Oracle Forms. In this post i am going to create LOV for Department and Job entities. Do the following steps to create LOV in ADF.


1) Add Departments and Jobs Entities
2) Add View Objects for Departments and Jobs LOVs
3) Create LOVs
4) Finally Link LOVs to JSF Page
Right click on adf.demo.model.view in Model project and choose Re-factor than Rename the  adf.demo.model.view to adf.demo.mode.queries for good naming convention.

Adding Departments and Jobs Entities
Right clicking on adf.demo.model.entities package in Model project and choose New Entity Object to Add Departments Entity.

Create Simple ADF Form using Oracle JDeveloper 11g

Image
In this post i will show you how to create simple ADF Form using Oracle JDeveloper 11g. I have create simple employee form based on employee table i.e. created in database. Using following steps i have create the form.

1) Create Application and Entity Objects 2) Create View Objects based on entities 3) Linking View Objects with Application Modules 4) Finally Create JSF Page
Pre-requisites
1) Oracle JDeveloper 11g 2) Employee Table in Oracle Database

Create Application and Entity Objects
Open JDeveloper and chose default role.

My First Form in Oracle ADF

Image
Given Below Screen Shoot is my first ADF Form. I have create this Form Using Oracle JDeveloper 11g and it very exciting to work in Oracle Fusion Middleware Tool. In the next post i will show you how to create simple form in Oracle JDeveloper 11g. I am beginner in JDeveloper 11g and still exploring this tool.