Oracle Articles Examples, Tutorials and Articles

Tables (GENERAL LEDGER)

Published by

shrikantgarud

No code has to be inserted here. ...

Tables (HR)

Published by

shrikantgarud

No code has to be inserted here. ...

Tables (INVENTORY)

Published by

shrikantgarud

No code has to be inserted here. ...

We Can Import any text data file into a oracle table

Published by

sabyasachi

To Import Text formated data into oracle table we have to create a table and a control file according to the text file.
textfile:-
10001 20056 12122009
10002 20036 12112009
10002 20236 12122009
10002 20776 12112009
10002 20346 12112008

Rename ...

1 Comment

Oracle Forms Triggers On Different Levels

Published by

sabyasachi

Block Processing Triggers:

When-Create-Record: Perform an action whenever Form Builder attempts to create a new record in a block. For example, to set complex, calculated, or data-driven default values that must be specified at runtime, rather than design time.

When-Clear-Block: ...

1 Comment

Oracle SQL Tuning

Published by

sabyasachi

USE EXISTS IN PLACE OF DISTINCT
visit for more information "allmyneed.blogspot . com"

The DISTINCT combination of deptno and dname columns have to be displayed. Only those rows need be displayed, whose deptno exists in the EMP table.

Query 1

Code sql:

SELECT

...

1 Comment

How to migrate oracle forms10g to ADF/JAVA Application?

Published by

salmankhalid

Oracle JHeadstart 11g for ADF

Oracle JHeadstart 11g for ADF dramatically improves developer's productivity for the Oracle Application Development Framework (ADF). It allows IT organizations to rapidly introduce Java EE, without the need for a team of JEE gurus to build ...

4 Comments

To find Expression Names in Discoverer Reports

Published by

malli_18arjun

To find Expression Names in Discoverer Reports

By using this query ,Expressions defined for object can be queried

Code sql:

SELECT   a.exp_name, b.obj_name, a.exp_formula1, c.fun_name
    FROM eul4_us.eul4_expressions a JOIN eul4_us.eul4_objs b
         ON b.obj_id

...

JAVA class files in oracle PLSQL

Published by

salmankhalid

We can use the JAVA class file in our PLSQL code
Follow the steps.

1 - Make a java class

For example:

Code :

Public class SimpleJava {
public void main(String[] args) {
System.out.println("Here we are"); 
}

...

1 Comment

Content Server Security 'Guest Account'

Published by

ILINX

If you have a site with content being published for public consumption in a structured website framework they can also be accessed by the UCM Guest account. Several sites are currently available on the Internet where you can use the guest account to access these documents using the standard UCM search ...

4 Comments