I came across metalink note 466931.1 "Oracle Database 11g Top New Features : Summary" today searching for something else and noticed mention of an 11g feature I had not seen in any previous materials, or in the 11g documentation online.
quote:
<i...
I need a sample script (PL SQL) to load a XML file from a local or mapped drive into a oracle database. The plan is load the xml file into a stage table.
CREATE TABLE Stage_BD (
id NUMBER(15)
, xml_file XMLTYPE
, time...
Hi Tom,
Can we create and use DBMS_UTILITY.LNAME_ARRAY / DBMS_UTILITY.maxname_array TYPE in Oracle 8.1.7 by calling Oracle 9i {ORACLE_HOME}/rdbms/admin/dbmsutil.sql ?
Thanks
-Moni
Hi Tom,
I have two users "A" and "B" both have same procedures "MY_PROCEDURE" and "P"
and "create and drop any context grants"
On user "A" I created context MY_CTX and Procedures.
create or replace context MY_CTX using MY_PROCEDURE;
cre...
Hi Tom,
Our Developers want an automatic way to (re)synchronize certain tables in QA environment with production data.
I haven't gotten all requirements yet, but it looks like they are wanting to get the data in sync on QA (after changing credi...
<code>Tom ,
I've got a few questions about you new book.
1.How is your new book different than the older one?
After reading the drafts I kind of figure(don't get me wrong here) might be getting a little repetitive there(wrt your older book--althou...