Technology at its Best

Implementing Zoom

2007-02-03T21:02:00.000-08:00

In the custom.pll, modify the below given function and procedure:function zoom_available return boolean is form_name varchar2(30) := name_in('system.current_form'); block_name varchar2(30) := name_in('system.cursor_block');begin if (form_name = 'POXPOEPO' and block_name = 'PO_LINES') return TRUE; else return FALSE; end if;end zoom_available;procedure event(

Hierarchical Query Example

2007-01-25T00:01:00.000-08:00

Hierarchical query:This query lists the employee_details with their manager in hierarchical manner from employees table.SELECT a.employee_id, a.first_name, a.last_name, a.manager_id, b.first_name mgr_first_name, b.last_name mgr_last_nameFROM ( select employee_id, first_name, last_name, manager_id from employees

Top-n and nth Least query

2007-01-18T00:20:00.000-08:00

Top-n query: Query to find the nth highest salary and theassociated employees from employees tableselect a.last_name,a.salaryfrom employees awhere n = (select count(distinct(b.salary)) from employees b where a.salary <= b.salary) nth least query: Query to find the nth least or say 2nd least salary andthe associated employees from employees tableselect a.last_name,

Reports Using XML Publisher

2006-11-27T05:06:00.000-08:00

XML Publisher Concurrent Program - XMLP Written by Anil Passi -- One of the Author I like. He writes very well. Friday, 24 November 2006 In this article I have listed a step by step demo of XML Publisher as a Concurrent Program in Oracle Apps. I think it is

Image File Attachment in Oracle 11i.

2006-11-14T03:34:00.000-08:00

Technical Details of Image File Attachment in Oracle Applications 11i.Attaching an image file in Oracle Apps say, you attach an image of an Item.For this you will click on the attachments icon(Paperclip Icon) of the toolbar in Apps Window and this will take you to Attachment Window.Here You can specify Category, Description,Datatype.If you select "File" as datatype, you will be taken to a webpage

Returning a Table from a PL/SQL function

2006-11-07T12:07:00.000-08:00

1. Create an object type for the recordcreate or replace type emp_rec_t as object( employee_id number, first_name varchar2(25), salary number, manager_id number, department_id number);2. create a SQL table type objectcreate or replace type emp_tab as table of emp_rec_t;3. Define a function in the following way.create or replacefunction demo_proc( p_start_row in number,

Lock a folder without any software

2006-11-04T13:05:00.000-08:00

Hey Buddies..Here is a trick to lock the folders without using any software: • Lock a folder without any software Suppose you want to lock the folder games in d: which has the path D:\Games.Follow the below steps: 1. In the same drive create a text file and type ren games games.{21EC2020-3AEA-1069-A2DD-08002B30309D} Now save this text file as loc.bat 2. create another text file and type

External Table feature of Oracle 10g on Windows

2006-11-04T05:35:00.000-08:00

Using External Table feature of Oracle 10g on Windows: External Tables are used for dataloading to oracle 10g Database. 1. Create a Directory C:\wkdir 2. connect to sqlplus as system or sysdba 3. Execute the below statement create or replace directory ext_tab_dir as 'c:\wkdir'; grant read,write on directory ext_tab_dir to scott; Here scott is the schema from where you will be creating