Welcome to OracleBabu

Employee Referral Robert Bosch - Freshers written test on 02.01.2010

2009-12-30T21:34:00.001-08:00

Robert Bosch Engineering and Business Solutions (RBEI) is conducting a Freshers Written Test on 2nd January 2010,
It is a open selection process for all B.E/B.Tech [ E&E, E&C, E&I, Telecom] students 2009 batch

Written Test Details: Criteria:- Aggr 70% and above
Venue:- Bangalore Institute of Technology
K.R road, V V puram, Bangalore - 560004
Reporting time:- 9.30am

Candidates who have attended our written test in the last 6 months are not eligible to take the test.

Test will comprise Technical + Aptitude questions and test of English language.

Selection Process: Shortlisted candidates will be invited for the personal interview. Details and venue of the interviews will be sent by mail.
Please bring 2B Pencil and Eraser without fail. You will be required to mark the answers with pencil.

Candidate has to carry the copy of mail from employee having this recruitment information, identity proof alongwith Degree Certificates/convocation certificate..
Plan sufficient travel time to reach the venue. If you are from outside Bangalore, please get to know the location and route to reach the venue on time.

Note: - Only E & C, E & E, Instrumentation Engg., Telecomm Engg., Medical Electronics candidates with 70% and above will be allowed for the written test

Oracle Vs Other DataBases

2009-12-30T21:32:00.000-08:00

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.

Overview of PL/SQL Programs(PL/SQL) 1 :

2009-12-30T21:27:00.001-08:00

Overview of PL/SQL Programs :

1) Describe a PL/SQL program construct
2) List the components of a PL/SQL block
3) List of benefits of subprograms
4) Describe how a stored procedure/function is invoked

==> Describe a PL/SQL program construct:

The basic unit of PL/SQL is block.

Block is divided into Declarative,
Executable and Exception Sections.

Executable section is required and all
other sections are optional.
You can nest blocks in the executable
and exception handling sections of a
PL/SQL block.

Declarative Section :

In declarative section, we define and
initialize the variables ,local
subprograms and cursors used in the block.

Declarations are local to blocks.

Executable Section :

In this section , we manipulate the
variables and cursors declared in the
Declarative section of PL/SQL block.

Executable section must also contain
at least one executable statement.

Exception Handling Section :

In this section, user can detect and
process the errors. This block is used to
respond runtime errors encountered by the
program.

When user defined or system related
exceptions are encountered the control
transfers to exception handling ( error
handling) section.

User defined exceptions are those which
are declared by the user.
Predefined exceptions are raised
automatically for common errors by PL/SQL.

Example of PL/SQL Block :

==> List the components of a PL/SQL block :

Block Structure ::

There are two kinds of blocks : Anonymous and Named Blocks.
Anonymous blocks are generally constructed dynamically and executed only once.

Eg :

Named Blocks are blocks that have a name associated with them. Named blocks can be divided into three types : Labeled

Label blocks are anonymous blocks with a label that gives the block a name. Label allows you to refer to variables that otherwise would not be visible.

Subprograms consist of procedures and functions. They can be stored in the database as stand alone objects , as part of a package , or as methods of an object type.

Triggers consist of a PL/SQL block that is associated with an event that occurs in the database. Triggers are executed implicitly whenever the triggering event occurs. The event can be DDL,DML or DCL.

==> List the benefits of subprograms :

Subprograms are named PL/SQL blocks that can be called with a set of parameters. Procedures and Functions collectively known as subprograms.

=>Subprograms let you break a program down into manageable, well defined modules.

=>Subprograms promote reusability. Once created, it can be reused in any number of applications.

=>Subprograms promote maintainability. You can change the internals of a subprogram without changing other subprograms that call it.

=>Subprograms can make your code even more reusable and maintained by grouping the subprograms into a PL/SQL package.

Many database applications are built using either a client/server or 3-tier model. In client/server model , the program sends requests to a database server for information. If this request done using SQL, it result in many network trips, one for each SQL Statement. Several SQL statements can be bundled together into one PL/SQL block and sent to the server as a single unit. This results in less network traffic and a faster application.

==> Describe how a stored procedure/function is invoked :

A procedure call is a PL/SQL statement itself.
Functions are called as part of an expressions.
VAR_NAME := Func_Name(PAR1,PAR2…);

To execute a procedure the user should have EXECUTE privilege on that object.

Grant Execute on proc_name to user_name;

If the user has execute privilege , he can execute the procedure even if the user does not have privileges on any of the tables that procedure uses.

The syntax used to execute a procedure depends on the environment from which the procedure is called. In SQLPLUS, a procedure can be called using the execute command, followed by procedure name. Any arguments to be passed to the procedure must be enclosed in parentheses following the procedure name.

Execute PROC_NAME(2,’BABU’);

The above command will execute proc_name procedure with
2 and ’BABU’ as parameters.
Within a subprogram the procedure can be called without the execute command.
To execute a procedure owned by another user, you must either create a synonym for that procedure or reference the owner’s name during the execution,

Execute owner_name.proc_name(2,’BABU’);

When executing remote procedures, the name of a database link must be specified.

Execute PROC_NAME@rem_db_link(2,’BABU’);

CALL Statement :

This can be used to call both PL/SQL and java subprograms. CALL is a SQL statement. It is not valid inside a PL/SQL block, but is valid when executed using dynamic SQL.

CALL SUB_PROG_NAME;

Calling Functions from SQL :

We can call function using an SQL Statement.
Select Func_totmarks(2) from students;

Sreekanth Babu V ( sreekanthbabu.vakiti@gmail.com)

References :

Oracle University books,

Oracle: The Complete References ,

Oracle 9i PL/SQL Programming

Freshers Recruitment in ROBERT BOSCH...2009 freshers...

2009-09-17T11:10:00.000-07:00

Robert Bosch is conducting a Freshers Written Test in Bangalore on 26th Sept 2009.

Eligibility:- 2009 Batch BE / BTech (E & C, E & E, Instrumentation Engg., Telecomm Engg., Medical Electronics)- 1st Class degree with over 70% aggr.

How to Apply :Suitable candidates can register and apply using the following link http://www.firstnaukri.com/fsjobsearch/mn_newsmartsearch.php?xz=7_0_5&qc=121866&tem=bosch

Written test call letters shall be intimated to the shortlisted candidates with information on venue and time.

Those who have taken the test in the last six months need not apply.

Last chance to save on Oracle Certification

2009-03-17T20:56:00.000-07:00

Last chance to save on Oracle Certification:
( By Oracle University )
SAVE 25% of all Oracle9i and 10g Exams -HURRY BOOK YOUR SEATS NOW!( Limited seats per week per centre)

For More Details and Registration: Click here

Oracle Certification A to Z : Click Here

Oracle Certification Exam Category Price (Rs)
Oracle 9i SQL 3030
All other Oracle 9i & Oracle Database 10g Exams 3983
All Oracle Database 10g Application Sever Exam 3983
Oracle Middleware Exams(Incl. select Hyperion) 3983
All Siebel Exams 8290
All Oracle E-Business Suite 11i (Finance and Supply Chain) 8290
Oracle E-Business 11i Essentials 4040

Exam Dates: 21st, 28th March 2009

Please contact the below Oracle Representatives for exam details.
Location Contact us
Bangalore 080 41088235
Chennai 044-66346114
Delhi 011-46509015
Hyderabad 040-66397157
Kolkata 033-66162000
Mumbai 022-67711214
Ahmedabad 079-40024246
Pune 020-66321113 / 9326727519
Nagpur 080 41088036
Chandigarh 080 41088036
Coimbatore 080 41084657
Jaipur 080 41088036

To Learn More on Oracle Certification, call 080- 41088012 or 91-9900521221
email : susheela.nagarajan@oracle.com

Thanks and Regards,
Sreekanth Babu V

Apex 3.2 now available :

2009-02-17T21:05:00.000-08:00

Apex 3.2 now available :
Background :
Oracle Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure.
===>>>>>
What is special about this version. Converting(Migrating) oracle forms to Apex.
How It converts : Oracle Form -> XML file -> import to APEX

Check the following(attached) image for more understanding:

Limitations :

=>> Form with block based on procedure are not considered.
=>> APEX prefers names in uppercase (tables and objects)
=>> It supports higher versions 9i or above.

The other useful links :
Free hosted development environment : Click Here

Much awaiteing Apex 3.2 now available on apex.oracle.com(David Peake) : Click Here
Reactions from users(Especially SCOTT) : Click Here
New Features of APEX 3.2 : Click Here

Best Regards,

Sreekanth Babu Vakiti

Oracle Update For July

2008-08-07T21:32:00.000-07:00

This Months Highlights:-

Special Offers on Oracle certification from Oracle:
Oracle University offering special offers on oracle certification. Candidates has to take the exam in oracle testing center. This offers are available till august 30th.Any Saturday in august you can register for the exam.

Special Offers Click Here
For further information pls contact : Susheela.nagarajan@oracle.com
or call 080-41084663.

Oracle PL/SQL Advanced Developer Certified Professional (OCP) :
Oracle University anounced new certification path for PL/SQL developers. Earlier to become OCP, developers has to complete 1Z1-141(Oracle Forms : Build Internet Application) after OCA. By introduction of this new path, developers can take 1Z1-146 (Oracle PL/SQL Advanced Developer) exam and become OCP(Oracle PL/SQL Advanced Developer Certified Professional ).
1Z1-141 beta will be released on August 20, 2008 in prometric testing centers world wide.
You can check the path here : http://twitpic.com/59s5
Syllabus and other details can be found in the below locations :
Syllabus for the exam
Details of the Exam
Oracle Certification A to Z :
Certification A to Z

Oracle Certification blog :
New Oracle Certification Program Blog has been started from oracle. All the information related to certification will be published here.
http://blogs.oracle.com/certification/

Oracle issues zero-day security alert :
For the first time in more than three years, Oracle releases an out-of-cycle patch security alert. Oracle has had an interesting record for the past three and a half years when it comes to security. Since January 2005, Oracle has not had to release an out-of-cycle security alert for its products.
That record ended this week with the public report of a serious vulnerability in Oracle's BEA WebLogic Web server, which rates a 10 on the Common Vulnerability Scoring System (CVSS) scale. Oracle has posted an alert for a serious flaw in its WebLogic Server and Express products. The issue lies within the Apache Connector component used by both systems, and attack code is publicly available.Oracle warned that the attack could be remotely exploited by an attacker without the need for any authentication information, and could give control over the targeted system.
<< Other Details >>

Oracle, SAP War Continues :
<< Oracle Vs SAP 1 >>
<< Oracle Vs SAP 2 >>
<< Oracle Vs SAP 3 >>

Oracle updates free Berkeley DB :

Oracle announced new releases of Oracle Berkeley DB, Oracle Berkeley DB XML and Oracle Berkeley DB Java Edition. The new releases and enhancements signify Oracle's commitment to continued innovation across the Oracle Berkeley DB product family, while maintaining the open source dual license business model.
*** Berkely DB is a library that provides a high-performance embedded database, with bindings in C, C++, Java, Perl, Python, Ruby, Tcl, Smalltalk, and many other programming languages. Berkeley DB was first developed at the University of California. *****

Oracle Corporation to acquire Carry-based Knowledge Software LLC :
Oracle announced Software giant Oracle Corporation has informed that it has reached an agreement with Global Knowledge Inc., to acquire its software division christened Knowledge Software (GKS) LLC.Oracle plans to form a global sales unit to expand its focus on non-Oracle applications using Global Knowledge products, which it said would extend its software training offering.
<< Other Details of the NEWS >>

SAP, Oracle and Citrix Increase Software and Support Prices :
SAP will be increasing maintenance fees from 15% to 22% of the cost of the initial software license. Oracle will raise software license fees from 15% to 20% in the U.S. while prices in Europe held steady and some regions experienced a decrease in price.
Citrix Systems is likely to follow software giants Oracle and SAP by raising prices. The company that pioneered Windows thin-client computing said that the decline in the value of the dollar against other currencies was forcing its hand.

Oracle stays on top as database sales show healthy growth :
Oracle once again took the top spot, capturing 44.3 percent of the market with revenue growth of 13.3 percent. IBM came in second with a 21 percent share, also logging a 13.3 percent revenue growth rate. It was followed by Microsoft, with 18.5 percent of the market and a 14 percent jump in revenue.
<< Oracle on the top >>

Useful plsql scripts from Oracle ricks:
There are some useful pl/sql scripts in this page.
<< OracleTricks Link >>

Some Changes in Oracle PartnerNetwork:
===================== From Oracle =======================
OPN Program
Oracle PartnerNetwork Criteria and Benefits Updates
Changes have been made to strengthen the Oracle PartnerNetwork (OPN) Program and help nurture our partners growth.
The newly revised OPN Program will:
• Better reflect the types of companies we do business with.
• Establish criteria for membership upgrades that are aligned with our partners' business models.
• Offer benefits to help develop our partners businesses.
Why are we making these changes?
Oracle is constantly looking to improve and update OPN to ensure that the program:
• Supports our partner community's business with Oracle.
• Is comprehensive and flexible to allow new partner types to join Oracle's economy.
• Offers tools and resources to help our partners grow their Oracle portfolio.
What is being Updated?
The areas where you will find changes are:
• Hosting Partner Type definition
• Staff Competency Table
• New Section added to the Benefits Table highlighting Membership Benefits and Tools
Who will be Impacted?
All partners in OPN looking to upgrade to Certified Partner (CP) or Certified Advantage Partner (CAP) will be affected, as well as new partners joining OPN.

When will the changes take effect?
• The benefits and partner type changes are effective immediately.
• For existing Partners applying for an upgrade:
• Before Oct 1, 2008: Your upgrade will be processed under the old Staff Competency table and you will have a 3 month grace period to achieve the new requirements for your level.
• After Oct 1, 2008: Your upgrade will be processed using the new criteria.
===================== From Oracle =======================

Best Regards,
Sreekanth Babu V

Oracle Update for May

2008-06-05T21:13:00.000-07:00

Oracle 11g Forms New Features:

Good news for Forms developers, At last the Forms modernization page has some content. The link for forms new features has been enabled and Case Study in Modernization is ready.
As we heard before Interoperability, Deployment and Administration are the focus for this new Forms version.

Oracle Forms 11g New Features :

-> External Events
BPEL (Business Process Expression Language)
Asynchronous Events
-> JavaScript Integration
-> Proxy User Support
-> EM Integration
-> Java Pooling for Reports
-> Java Events ( Making PJCs capable of raising events on the server
-> PL/SQL Tracing (Enhancements for existing PL/SQL Tracing)
-> Oracle Diagnostic Logging

Don’t forget to watch the below link for new features of Oracle Forms 11g:
http://download.oracle.com/otndocs/demos/modernizeforms/New_v11_features/New%20v11%20features.html

Forms modernization page :
http://www.oracle.com/technology/products/forms/forms_modernization.html

Case Study in Modernization :
http://www.oracle.com/technology/products/forms/pdf/formssoa_case_study.pdf

Oracle 11g Forms Release :

One more news is that Oracle 11g forms is targeted for release later this year. It was supposed to be in production in FY 2008(May 2008). When I wrote to Grant Ronald (Group Product Manager in Oracle's Tools Division) asking about 11g forms , he replied me saying “It is targeted for release later this year”.

Do you know?

=> Oracle Application Server 10g Release 2 (10.1.2) was released in two phases.
The first phase (version number 10.1.2.0.0) contained several components such as Oracle Portal, OracleAS Containers for J2EE (OC4J), Oracle Discoverer, and so on. But this phase did not contain certain other components such as Oracle Reports, Oracle Forms, and so on.
The second phase (version number 10.1.2.0.2) contains all the OracleAS components,including phase 1 components, Oracle Reports, Oracle Forms, and so on.

=> Larry Ellison ($26 billion) is America's 4th richest:
Larry Ellison chief executive of Oracle Corporation the is the 4th richest according to Forbes Magazine’s latest list of the wealthiest Americans. Microsoft founder Bill Gates is the richest person in America.
=>Since release 9i, Oracle Reports uses Business Intelligence Beans (BI Beans) to create and display graphs in reports. There is no direct migration path from Oracle Graphics to the BI Beans graphing functionality. As such, the user will need to rewrite all of their graphs using oracle using the new Graph Wizard within the Oracle Reports Builder 10g.

=>Oracle Express data source is deprecated in Oracle Reports 10g Release 2 (10.1.2). You should plan to migrate your Express data to the OLAP option provided with Oracle Database. Use OLAP data source in Oracle Reports 10g Release 2 (10.1.2) to create your reports based on OLAP data.

Closing and hiding of browser-window in forms :

Nice articles by Gerd Volberg.
Hiding the browser window when you start the application :
http://talk2gerd.blogspot.com/2007/10/forms-startup-part-1.html
Closing the browser window when you shutdown the application :
http://talk2gerd.blogspot.com/2008/06/forms-shutdown.html

Oracle Buys AdminServer :

Expands Oracle’s Applications Drive into Insurance
On May 13, 2008 Oracle announced it has agreed to acquire AdminServer, a rapidly growing provider of insurance policy administration software. AdminServer's product offering will become a core component of Oracle's existing insurance industry software footprint that is already used by more than one thousand insurers including 20 of the top 20 global insurance companies.

For Other details Check the following link :
http://www.oracle.com/corporate/press/2008_may/adminserver.html

i-flex solutions limited to change its name to Oracle Financial Services Limited ::

The Board of Directors of i-flex solutions Ltd. (Reuters: IFLX.BO & IFLX.NS) at its meeting held today in Mumbai, approved a proposal to change the name of i-flex solutions Ltd. to Oracle Financial Services Limited, subject to regulatory and shareholder approvals.

=> i-flex provides IT solutions exclusively to the financial services industry worldwide.
=> Oracle Global holds 80.58% shares in i-flex solutions
=> i-flex is a world leader in providing IT solutions to the financial services industry, with more than 790 customers in over 130 countries
=> The i-flex products portfolio consists of FLEXCUBE—the world's No. 1 selling core banking solution for five consecutive years—2002-2006 by the UK-based International Banking Systems (IBS).

For Other details Check the following link :
http://www.oracle.com/corporate/press/2008_apr/ofs.html

Oracle and Satyam Computers to Co-Develop Business Process Integration for Product Lifecycle Management (PLM):
Oracle and Satyam Computer Services, Ltd., a leading global consulting and IT services provider, announced a co-development agreement to build Oracle Application Integration Architecture (AIA) Process Integration Packs for Enterprise Product Lifecycle Management (PLM). The PLM Process Integration Pack will enable rapid implementation of Oracle's next generation integrated enterprise PLM processes and will help customers in reduce the cost and risk associated with typical third-party and custom integrations.
For Other details Check the following link :
http://www.oracle.com/corporate/press/2008_apr/aia-satyam.html

Oracle Technology Network Developer Day, Bangalore:

Last month , I attended Oracle Technology Network Developer Day, Bangalore. It was a gr8 experience for me. The focus was on the Open Source Software from oracle. Please find the presentations of the developer’s day:

To access the presentations made at the Oracle Developer Day, kindly click on the links below:
=>Getting started with Oracle Database development
=>Oracle SQL Developer Overview, New Features and the Future
=>Oracle Application Express, an alternative for Forms and Reports Developers
=>Migrating from 3rd Party Databases to Oracle Database 11g
=>Upgrading to Oracle Database 11g , What you need to know!
=>Java and scripting languages with Oracle Database 11g
For additional technical information on theses technologies, please visit http://www.oracle.com/technology
Other important links you could access for more information are:

=> Oracle Database 11g: http://www.oracle.com/database
=> Service Oriented Architecture: http://www.oracle.com/soa
=> Java: http://oracle.com/technology/java
=> Oracle Database 10g Express Edition:
http://www.oracle.com/technology/products/database/xe
=> Oracle JDeveloper: http://www.oracle.com/technology/products/jdev
=> Oracle SQL Developer:
http://www.oracle.com/technology/products/database/sql_developer
=> JavaServer Faces: http://www.oracle.com/technology/tech/java/jsf
=> Enterprise JavaBeans 3.0:
http://www.oracle.com/technology/tech/java/ejb30
=> BPEL: http://www.oracle.com/appserver/bpel_home
=> Web services: http://www.oracle.com/technology/webservices
=> Oracle Application Express Edition:
http://www.oracle.com/technology/products/database/application_express
=> J2EE for Forms/ Designer Developers:
http://www.oracle.com/technology/products/jdev/collateral/4gl/formsdesignerj2ee
=> Oracle VM: http://www.oracle.com/technology/tech/virtualization

?? ? ? Future Of Oracle Forms ?? ? ?
Hi,
What is the future of oracle forms? If you have any queries or opinions or suggestions anything related to above please mail me.
==> Sreekanth Babu Vakiti (Vakiti.sreekanth@gmail.com)

Best Regards,
Sreekanth Babu V

Oracle Certification A to Z

2008-04-29T05:45:00.001-07:00

Referal Walk-in in RBEI(BOSCH) for SAP Technical (Sr. ABAP) and SAP HR Functional on 8th May 2008
For various it jobs information :
http://www.info-it-jobs.blogspot.com/

Oracle Certification A to Z :

Oracle Certification program is for oracle professionals offered by Oracle Corporation.

This can divided into three levels,
OCA (Oracle Certified Associate ) ,
OCP (Oracle Certified Professional ) and
OCM (Oracle Certified Master )

OCA can be taken by junior team members and it is like foundation.
Others with knowledge of oracle can also try for this exam.
OCP is for programmers and senior programmers, who have got enough experience in oracle.
OCM is for the people, who has experience on a wide variety of topics in oracle database.

By August 2007 there were 42000 professionals in India.Now it might have crossed 50000. When you say certification.

List Of Certifications offered by Oracle ::
Certification List

List Of Exams ::
Examination List

Certification FAQ :
Certification FAQ from ORAFAQ

You can Refer the following books :
Oracle Press
Sybex
Oracle documentation
Oracle Forums

Practice exams (Oracle Recommends) :
http://www.selftestsoftware.com/dept.aspx?dept_id=6000
http://www.transcender.com/dept.aspx?dept_id=130000

Other Useful Links :
http://www.dbapool.com/
http://www.ucertify.com/vendors/Oracle.html
http://www.pass4sure.com/Oracle-index.html
http://certification.about.com/od/oracle/Oracle_Certification_Resources.htm
http://www.oraclesource.net/

For attending Online Exam.:
Online Oracle Certification Exam

Register for exam in Oracle Testing Center :
Register For Oracle Certification Exam From Oracle Testing Center

Special offers on certification exams this month:
Special Offers

Register for exam in Prometric center :
Register For Oracle Certification Exam From Prometric Center

New Oracle Database 11g OCP Certification Exams now in Beta! :
Oracle 11g OCP Certification

*Trainings :
Trainings

Oracle DBA Certification Details :
Oracle DBA Candidate Guide

Oracle Forms Developer Certification Details:
Oracle Forms Developer Candidate Guide

Sample Papers and Model Papers can be downloaded from following link (Which is from esnips):
Sample Papers and Model Papers and Other Details

Best Regards,
Sreekanth Babu Vakiti

Referal Walk-in in RBEI(BOSCH) for SAP Technical (Sr. ABAP) and SAP HR Functional on 8th May 2008

For various it jobs information :
http://www.info-it-jobs.blogspot.com/

Oracle Update - March 2008

2008-03-24T19:46:00.000-07:00

Oracle Update :-

This Months Highlights:

1) Certification Becomes Cheaper – Certify Yourself
2) Different Oracle Tools
3) Why Only Oracle ?
4) Severity Vs Priority
5) Oracle 11g Pl/Sql new Features.
6) Interesting Queries & Topics

Certification Becomes Cheaper – Certify Yourself :

Certification prices are going down as the dollar price has become lower. Oracle University gives discounts on some certifications on certain dates, Where candidate has to take up the exam in the given location. Now it is very simple to register for exam.

Check the link below for registering the exam :
http://www.oracle.com/global/in/education/exam_request_2008.html

List of exams available :
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=42

Different Oracle Tools :

There are different oracle tools available in market. Check the advantages and disadvantages of different tools.

Oracle Tools ::
http://www.orafaq.com/tools/
Comparison table for Oracle tools ::
http://www.orafaq.com/tools/comparison

TOAD (From QUEST) is the number one in the market.
About Toad :
http://www.quest.com/toad-for-oracle/

Toad Freeware Download Link::
http://www.toadworld.com/Downloads/tabid/60/Default.aspx
http://www.toadsoft.com/

Why Oracle :

Read the explanation given by Tom Kyte by comparing the other databases :
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1886476148373

Seviority Vs Priority :

Seviority : Seriousness of the defect.
Priority : How Quickly the bug should be fixed.

Priority is Business and Severity is Technical.Many people think, High seviority bugs should be taken on High priority. But in real scenario, High seviority bugs may or may not be taken on High priority.
Below are few examples where we can have ‘High priority & Low Seviority’ and ‘High Seviority and Low Priority’ bugs.

1] High Severity And Low Priority----If there is an application , if that application crashes after multiple use of any functionality
Means High Severity because application crashed, Low Priority because no need to debug right now you can debug it after some days.

2] High Priority And Low Severity :
If the logo of any site is wrongly spelled, Priority is high but severity is low.
Because it effect the name of the site, it is important to do quick.
It is not going to crash because of spell change, so severity low.

Oracle 11g Pl/Sql new Features:

Nice Explanation with examples :
http://www.oracle-base.com/articles/11g/PlsqlNewFeaturesAndEnhancements_11gR1.php

Interesting Queries & Topics:
==>>>
In Oracle 11g , No need to use the dual table for getting the next value or current value of a sequence.
Eg:
‘Select Sequence_Name.NextVal into ln_seq from dual’
can be replaced by
ln_seq:= Sequence_Name.NextVal;

==>>>
The following query gives you the Schema name , Connection Status , OS User , Terminal and the number of sessions :

*************************************************************************************

SELECT
DBA_USERS.USERNAME "Schema_name",
DECODE(V$SESSION.USERNAME, NULL, 'NOT CONNECTED', 'CONNECTED') "Connection_Status",
NVL(OSUSER, '-') "OS_User",
NVL(TERMINAL,'-') "Terminal",
SUM(DECODE(V$SESSION.USERNAME, NULL, 0,1)) "No_Of_Sessions"
FROM
DBA_USERS, V$SESSION
WHERE
DBA_USERS.USERNAME = V$SESSION.USERNAME (+)
GROUP BY
DBA_USERS.USERNAME,
DECODE(V$SESSION.USERNAME, NULL, 'NOT CONNECTED', 'CONNECTED'),
OSUSER,
TERMINAL
ORDER BY 1 ;

*************************************************************************************
==>>>

What is the difference between ? and HELP?
There is no difference. Both "?" and HELP will read the SYSTEM.HELP table (if available) and shows help text on the screen.
To use the help facility, type HELP followed by the command you need to learn more about. For example, to get help on the SELECT statement, type:

Help Select
------------------------------------------------------------------------------------

What is the difference between @ and @@?
The @ (at symbol) is equivalent to the START command and is used to run SQL*Plus command scripts.
A single @ symbol runs a script in the current directory (or one specified with a full or relative path, or one that is found in you SQLPATH or ORACLE_PATH).

@@ will start a sqlplus script that is in the same directory as the script that called it (relative to the directory of the current script). This is normally used for nested command files.

------------------------------------------------------------------------------------

What is the difference between & and &&?
"&" is used to create a temporary substitution variable and will prompt you for a value every time it is referenced.
"&&" is used to create a permanent substitution variable as with the DEFINE command and the OLD_VALUE or NEW_VALUE clauses of a COLUMN statement. Once you have entered a value it will use that value every time the variable is referenced.

Eg: SQL> SELECT * FROM TAB WHERE TNAME LIKE '%&TABLE_NAME.%';
------------------------------------------------------------------------------------
What is the difference between ! and HOST?
Both "!" and "HOST" will execute operating system commands as child processes of SQL*Plus. The difference is that "HOST" will perform variable substitution (& and && symbols), whereas "!" will not. (Note: use "$" under MVS, VMS, and Windows environments, not "!")

------------------------------------------------------------------------------------
-->>
Sreekanth Babu Vakiti

Oracle Update

2007-12-26T07:51:00.000-08:00

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