Technology & Management Journal: April 2010

Friday, April 30, 2010

Useful Academic Recruitng and admission features

Academic Program/plan/subplan deactivation feature

Scenario is the program is never valid from a date or a term, still it should be active for the students who are already enrolled to that particular program.

This is achieved through the two fields in Academic program table. They are Last Prospect Date and Last Admit Term fields in the program page.

Batch Prospect/Application deletion

Now the delete process have redesigned with a batch process using population process and has options for 3c deletions.And the deleted data which is in the delete holding table can be utilized to view the prospect/application information using the link provided in the page. Which can be modified and deleted as required.

External education component redesign
component with fewer tabsdata entry sequence customizable by user

more robust transcript info layout

comment filed at transcript level

If a grade change happens in the external education page, history hyperlink shows the previous data

Thursday, April 29, 2010

Oracle Identity Manager - Quick Links

Table Triggers

Last week i heard my mangager asking my collegue to take the back of a table trigger. However i was not aware of the way the trigger back up is taken.

I got the information from my colleague itself. With that info i googled for the same. This link, will tell how to design,create and implement triggers.

If you want to know the trigger realted to a table, the following note will give youa quick update:

ALL_TRIGGERS describes owned by the current user and triggers on tables owned by the current user. If the user has the CREATE ANY TRIGGER privilege, then this view describes all triggers in the database.

Related Views
DBA_TRIGGERS describes all triggers in the database.
USER_TRIGGERS describes all triggers owned by the current user. This view does not display the OWNER column.

Click here to view the reference page

Monday, April 19, 2010

Some useful functions

In Oracle/PLSQL, the initcap function sets the first character in each word to uppercase and the rest to lowercase.

The syntax for the initcap function is:initcap( string1 )

string1 is the string argument whose first character in each word will be converted to uppercase and all remaining characters converted to lowercase.

Applies To:

Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For example:

initcap('tech on the net'); would return 'Tech On The Net'

initcap('GEORGE BURNS'); would return 'George Burns'

************************

In Oracle/PLSQL, the decode function has the functionality of an IF-THEN-ELSE statement.

The syntax for the decode function is:

decode( expression , search , result [, search , result]... [, default] )

expression is the value to compare.

search is the value that is compared against expression.

result is the value returned, if expression is equal to search.

default is optional. If no matches are found, the decode will return default. If default is omitted, then the decode statement will return null (if no matches are found).

Applies To:

Oracle 9i, Oracle 10g, Oracle 11g

For example:

You could use the decode function in an SQL statement as follows:

SELECT supplier_name,

decode(supplier_id, 10000, 'IBM',

10001, 'Microsoft',

10002, 'Hewlett Packard',

'Gateway') result

FROM suppliers;

The above decode statement is equivalent to the following IF-THEN-ELSE statement:

IF supplier_id = 10000 THEN

result := 'IBM';

ELSIF supplier_id = 10001 THEN

result := 'Microsoft';

ELSIF supplier_id = 10002 THEN

result := 'Hewlett Packard';

ELSE

result := 'Gateway';

END IF;

************************

Check for file existence:

If Not (FileExists(&Str_Filepath, %FilePath_Absolute)) Then

MessageBox(0, "", 0, 0, " *** Invalid File Path/ No write access -- Check the File Path <" | &Str_Filepath | ">");

Exit (1);

End-If;

Friday, April 9, 2010

Links in Portal

How to add links in the homepage? That was the question from my manager when one ticket related to the same came to the bucket. I thought of adding a content reference directly under the respective folder. But the best practice was something different.

There was an external section where all the non peoplesoft related links are created. Create the content reference there and then create the content reference link under the respective section.

Easy maintenance and accessibility. I am in pressed.

Search This Blog