During its lifetime, Oracle PL/SQL has become faster, easier to use, and richer in its feature set. Oracle Database 10g continues this PL/SQL tradition of speed, ease, and feature growth by offering a useful array of enhancements, including: –Dramatically faster excution speed, thanks to transp
Tag: Oracle
Oracle Dates and Times
A date type in Oracle stores both date and time. An internal format is used to represent values of date fields. Oracle provides a number of functions to work with date fields. These functions are reviewed here.
SQL scripts that compare schemas in two different instances for differences
(Ken Atkins) So you have your application installed in three different instances (Development, Test, Production). Or maybe that is six (conversion, demo, training), or eight? Well, how do you keep all of that in sync? No matter how good your migration procedures, differences between the instances so
Ellison gagging on PeopleSoft’s poison pill
(John Paczkowski) PeopleSoft may have finally found a way to stave off Oracle’s $7.3 billion hostile takeover bid. In a filing with the Delaware Court of Chancery, Oracle said that PeopleSoft’s customer-refund plan may force it to abandon its bid for the company.
Gbrowse for Oracle, PostgreSQL, and BioSQL
Generic Genome Browser – support for various databases and database schemas are coming. Right now, there is full support for the Bio::DB::GFF schema running on MySQL, preliminary support for the Bio::DB::GFF schema running on top of Oracle, preliminary support for the Bio::DB::GFF schema running on
Administering Real Application Clusters Databases with Oracle Enterprise Manager
This chapter describes how to use Oracle Enterprise Manager to administer Real Application Clusters databases. This chapter only describes Oracle Enterprise Manager administration for Real Application Clusters. Use this section as a supplement to information in the Oracle Enterprise Manager Administ
Valid SQL-JDBC Datatype Mappings
This chapter, from the online reference guide, contains detailed JDBC reference information, including the following topics: – Valid SQL-JDBC Datatype Mappings – Supported SQL and PL/SQL Datatypes – Embedded SQL92 Syntax – Oracle JDBC Notes and Limitations – Related Information
Specify Constraints in the Oracle XML DB
Oracle XML DB is a set of built-in high-performance storage and retrieval technologies developed especially for XML. It enables you to constrain XML data according to XML schema definitions and hence achieve control over relationships that structured data has always enjoyed. Alongside its other feat
Migrating Constraints from Oracle to SQL Server
Regardless of the database management system (DBMS) you are using, it is recommended that you always name your constraints. If you do not name your constraints, both Oracle and Microsoft® SQL Server™ name them for you. Because Oracle and SQL Server use different default naming conventions, the d
PeopleSoft sued over rebate program
(Ellen Lee) PeopleSoft Inc.’s “customer assurance program,” which allows customers to get up to five times their money back if Oracle Corp. succeeds in its $7.3 billion hostile takeover bid and dismantles PeopleSoft’s software, has come under the microscope after a group of shareholders asked a judg