Oracle Update

Hi,

This Month's Topics :

1) Release of Oracle 11G.
2) Certification Fee gets cheaper.
3) Compare Oracle with SqlServer&DB2.
4) Integrating Oracle Spatial with Google Earth
5) Oracle is Market Leader Again
6) Technical Talk ( Dynamic SQL)


1) Release of Oracle 11G.
On July 11, 2007, in a live launch event from New York City, Oracle unveiled Oracle Database 11g—the next generation of enterprise information management that will help you innovate faster through better business insight.
Oracle Database 11g
Oracle Database 11g, building on Oracle's unique ability to deliver Grid Computing, gives Oracle customers the agility to respond faster to changing business conditions, gain competitive advantage through technology innovation, and reduce costs.
With Oracle Database 11g you can:
Adopt new technology faster with Real Application Testing
Manage more data for less with advanced compression and partitioning
Simplify systems by storing all your data in the Oracle Database with Oracle Fast Files
Maximize the ROI of disaster recovery resources with new Data Guard advances
Free critical personnel for strategic tasks with management automation

2) Certification Fee gets cheaper( Discount by oracle + $ Value down ) :
40% DISCOUNT ON ORACLE CERTIFICATION

Exam Papers List Price After 40% Discount ed Price
Introduction to SQL Rs. 3840/- Rs. 2304/-
All other OCP Exam Papers Rs.5050/- Rs. 3030/-

For further details, www.oracle.com/education/certification.
Or
Contact: mailto:Edus_in@Oracle.com

3) Compare Oracle with SqlServer&DB2..

Oracle Vs DB2
Edison Group: Oracle Saves 38% in Database Management Cost over IBM After completing a laboratory study of standard RDBMS administrative tasks, measuring for efficiency (time it takes to complete tasks), analysts at the Edison Group found that "Oracle Database 10g Release 2 can provide organizations using the product with 38% annual administration-related time savings." The Edison Study: Comparative Management Cost Study: Oracle Database 10g Release 2 and IBM DB2 Universal Database 9.1, is now available.
STUDY DETAILS
Database administrators (DBAs) can perform typical administrative functions in 38% less time when using Oracle Database 10g Release 2 compared to IBM DB2 UDB 9.1.
Oracle Database 10g Release 2 requires 35% fewer steps for the same set of standard RDBMS tasks than IBM DB2 UDB 9.1 using Edison's metric for complexity assessment.
Benefiting from increased DBA productivity due to lower complexity and higher efficiency cited above, businesses could save up to $31,654 per year per DBA by using Oracle Database 10g Release 2 rather than IBM DB2 UDB 9.1.

Oracle Vs SQL Server
Edison study: Oracle extends DBA productivity advances over SQL Server 2000 and 2005
An independent Comparative Management Cost Study from the Edison Group proves Oracle Database 10g offers superior manageability, resulting in significant advantages and cost savings over Microsoft SQL Server 2000 and 2005.
The latest report demonstrates that Oracle's manageability advantage over SQL Server has increased since the last comparison.
In the previous study, Oracle Database 10g Release 1 had a 30% time advantage and 20% complexity differential with Microsoft SQL Server 2000, compared to the 38% time and 30% complexity differential that Oracle Database 10g Release 2 now holds over SQL Server 2005.
In the side-by-side comparison Oracle Database 10g beats Microsoft SQL Server 2005 because with Oracle:
--> Typical DBA functions are 38 percent faster
--> Requires 30 percent fewer steps, making it less complex
--> Businesses can save up to US $31,664 annually per database administrator (DBA)
With this study, Edison Group shows that DBAs can expect to be more proactive in dealing with emergencies and have more time to address strategic issues like database architecture requirements, while businesses can expect to reduce their cost of managing enterprise database systems by using Oracle Database 10g.

4) Integrating Oracle Spatial with Google Earth
Learn how to use Oracle Locator/Oracle Spatial, GeoServer, and Google Earth to create a seamless, robust system for location-enabled BI.
http://www.oracle.com/technology/pub/articles/lokitz-spatial-geoserver.html

5) Oracle is Market Leader Again
Gartner 2006 Worldwide RDBMS Market Share Reports 47.1% Share for Oracle
Gartner has published their market share numbers by operating system for 2006 based on total software revenues. According to Gartner, Oracle
Has 47.1 percent share (up from 46.8 percent in 2005) growing at 14.9 percent
Is growing faster than the market average of 14.2 percent with US$7.2 Billions in revenues
Continues to hold more market share than its two closest competitors combined
Worldwide Vendor Revenue Estimates from RDBMS Software, Based on Total Software Revenue, 2006 (Millions of Dollars)
Company
Worldwide Vendor Revenue Estimates from RDBMS Software, Based on Total Software Revenue, 2006 (Millions of Dollars)



For further details : http://www.gartner.com/it/page.jsp?id=507466
For further details : http://www.gartner.com/it/page.jsp?id=507466

6) Technical Talk ::

Example PL/SQL code to demonstrate Dynamic SQL :
rem -----------------------------------------------------------------------
rem Filename: dynasql.sql
rem Purpose: Example PL/SQL code to demonstrate Dynamic SQL
rem Date: 25-Feb-2003
rem Author: Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

CREATE OR REPLACE PROCEDURE CREATE_TABLE1 AS
sql_stmt varchar2(4000);
BEGIN
EXECUTE IMMEDIATE 'CREATE TABLE x (a NUMBER)';
END;
/
show errors

CREATE OR REPLACE PROCEDURE CREATE_TABLE2 AS
cur integer;
rc integer;
BEGIN
cur := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(cur, 'CREATE TABLE X (Y DATE)', DBMS_SQL.NATIVE);
rc := DBMS_SQL.EXECUTE(cur);
DBMS_SQL.CLOSE_CURSOR(cur);
END;
/
show errors

SET SERVEROUTPUT ON

CREATE OR REPLACE PROCEDURE DEPARTMENTS(NO IN DEPT.DEPTNO%TYPE) AS
v_cursor integer;
v_dname char(20);
v_rows integer;
BEGIN
v_cursor := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(v_cursor, 'select dname from dept where deptno > :x', DBMS_SQL.V7);
DBMS_SQL.BIND_VARIABLE(v_cursor, ':x', no);
DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor, 1, v_dname, 20);
v_rows := DBMS_SQL.EXECUTE(v_cursor);
loop
if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then
exit;
end if;
DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor, 1, v_dname);
DBMS_OUTPUT.PUT_LINE('Deptartment name: 'v_dname);
end loop;
DBMS_SQL.CLOSE_CURSOR(v_cursor);
EXCEPTION
when others then
DBMS_SQL.CLOSE_CURSOR(v_cursor);
raise_application_error(-20000, 'Unknown Exception Raised: 'sqlcode' 'sqlerrm);
END;
/
show errors


Best Regards,
Sreekanth Babu