Cursor to HTML in Oracle

Posted by mustapha under Oracle
Add comment | No Trackbacks
Thomas Kyte the guy of Oracle's Ask Tom page has in his blog a post about creating HTML from cursor. He uses the DBMS_XMLGEN.GETXMLTYPE to create the XML presentation of the cursor and then lXMLData.transform on a generic XSL to convert XML to HTML.

» Read More

 

Oracle Open World

Posted by mustapha under Oracle
Add comment | No Trackbacks
Cybernoon reported yesterday that Mumbai to host Oracle Open World.

Oracle India Private Limited (Oracle India) announced today that it will host the premier Oracle OpenWorld conference in Mumbai on January 10-11, 2006. Oracle OpenWorld is Oracle’s global technology and business conference for customers, partners, business and IT decision makers. India is one of the only two countries in the Asia Pacific region to host the conference in Oracle’s current financial year, June 2005 to May 2006.

» Read More

 

Multitable INSERT in Oracle

Posted by mustapha under Oracle
[5] Comments | No Trackbacks
Most INSERT statements are the single-table variety, but Oracle also supports a multiple-table INSERT statement. With a multitable insert, you can make a single pass through the source data and load the data into more than one table.

[ ALL | FIRST ]
WHEN condition THEN insert_into_clause [values_clause]
[insert_into_clause [values_clause]]...
[WHEN condition THEN insert_into_clause [values_clause]
[insert_into_clause [values_clause]]...
]...
[ELSE insert_into_clause [values_clause]
[insert_into_clause [values_clause]]...
]

» Read More

 

Oracle 10G New Purge feature

Posted by mustapha under Oracle
[7] Comments | No Trackbacks
Purge is useful in 10g when you want to "really truly drop a table". In 10g, tables can be restored after being dropped.

When you drop a table in 10g like this:
drop table table_name;

Oracle renames it (moves it to the recyclebin) and the table is not (truly) dropped.
You can get it back:

» Read More