A community portal about Oracle database with blogs, videos, and photos. According to Wikipedia.org: An Oracle database consists of a collection of data managed by an Oracle database management system. Popular generic usage also uses the...
[more]
A community portal about Oracle database with blogs, videos, and photos. According to Wikipedia.org: An Oracle database consists of a collection of data managed by an Oracle database management system. Popular generic usage also uses the term to refer to the Oracle DBMS management software, but not necessarily to a specific database under its control.
If you want to rename any column name in your table, you have to go manually. in 9i, 10g and higher versions you have simple statement to rename column name. See here http://msc-it.blogspot.com/2008/09/rename-column-name-in-oracle-8i.html Read Full Story
I wrote about the DBA at Certegy/Fidelity National Information Services that stole 2.3 million records and old them to a marketng company . Turns out that he got a lot more than that: Fidelity Nat'l Widens Scope of Theft .
Now it includes 1.4 million credit card records, including cards the Read Full Story
Yep. It is now available on OTN. Download Oracle 11g . The download is only for Linux right now but you can get the documentation and start reading through it.
Actually, you can save yourself a click and go directly to the Oracle 11g Document Library . It has a brand new look Read Full Story
LewisC's An Expert's Guide To Oracle Technology
This book, Physical Database Design , is sub-titled "The Database Professional's Guide To Exploiting Indexes, Views, Storage, and More". Not only is it a wordy sub-title, it's a deep read. This book is not a beginner's book. If you are an experienced database professional, I pretty mu Read Full Story
LewisC's An Expert's Guide To Oracle Technology
So, when does something become a fact of daily life rather than bleeding edge? I guess the New York Times is probably not that point, more like National Enquirer. Anyway, you know something is primed and ready to blow when the New York Time covers it. That's why I as happy to see Read Full Story
Another frequent question I get is a lot like an email I received just this morning:
Hi Lewis,
Can you please help me outâ¦..i want to change the datatype of column.
The existing column have datatype as CLOB and I want to change it to NUMBERâ¦..Is it possibleâ¦Also this column only have null valuesâ¦â¦.
I tried it on 10g but it was giving error
SQL> alter table onbs_xml_message modify (cc_message_sysid number);
ERROR at line 1:
ORA-22859: invalid modificati Read Full Story
The Oracle Developer Tools User Group (ODTUG) is in New Orleans again this year. It was held in New Orleans in 2005, the June before Katrina. I attended that one with my family .
This year will be an even bigger year and I have to give kudos to the conference leaders for choosing New Orleans again. New Orleans is open and ready to party.
One of the new items this ye Read Full Story
Una base de datos de enlace es la forma de Oracle le permite conectarse desde una base de datos a otro. Un enlace a la base de datos de una base de datos remota utilizando una ID y una contraseña al igual que un usuario, pero sólo permite el acceso programático. Base de datos permitirá a los vínculos de procesamiento distribuido. Replicación es un excelente ejemplo de una aplicación que utiliza la base de datos enlaces. Replicación de bases de datos Oracle utiliza vínculos con el movimiento... Read Full Story
I did not know XPath injection even existed. Kind of makes sense that it does though.
XPath is a way to address specific nodes in an XML document. For example, in this document:
<doc>
<Title>ABC Document</Title>
</doc>
I would address the Title element as: /doc/Title
Kind of like walking through directories on a disk. Of course, XPath can get much more complicated than that.
Anyway, XPath injection is like Read Full Story
