"This site may contain explicit descriptions of, or advocate one or more of the following: adultery, morbid violence, not easy to navigate, not loads quickly. It does not contain broken internal links, nonworking code, or misspellings and bad grammar, bad grammar and bad grammar. But then again, it may not. Who knows?"

Finaly long wait: Gallery 2.0 released!

I've tried long time ago gallery v2 beta mod and surprising their code, imp, feel & look etc.. I’ve waited for stable release and today I got mail from update g.mailing list telling
_______________________
We are very proud to announce that Gallery 2.0 final has been released
and is available for immediate download! This is a complete rewrite of
Gallery and is the culmination of 3 years of design and effort. We've
been through 4 alpha releases, 4 beta releases and 2 release candidates.
_______________________

oh time to test it then!


Export or import with Oracle Data Pump

In Oracle 10g, exp and imp have been redesigned as the Oracle Data Pump (although Oracle still ships and fully supports exp and imp). If you're used to exporting exp and imp, the Data Pump command-line programs have a syntax that will look very familiar. 

[ more.. ]


Passing SQL to Oracle's Heterogeneous Services with DBMS_HS_PASS THROUGH

Oracle's Heterogeneous Services layer is a way for an Oracle database server to access data on external, non-Oracle databases transparently using Oracle.

For example, you can configure Heterogeneous Services and SQL*Net to access a Microsoft Access database through ODBC or OLE DB. Afterwards, you can query the table as if it were in a remote Oracle database:

create database link using '';

select name,latitude,longitude from capital@;


[ more.. ]


Clone database objects with dynamic SQL

If you want to take a copy of one table and make a copy of it in another schema (under another username), you can use the SQL*Plus COPY command, or a simple <code>"create table foo as select * from other.foo;"</code>, as long as you have select privileges on the other user's table.

[ more.. ]


Page :  1