-
Oracle 11g Database Features
is required. Now you have no reason for not making everything a subroutine! Oracle 11g PL/SQL Features PL/SQL "continue" keyword This will allow a C-Like
Keyword tags:
None
Last updated:
Jul 8 2008, 6:44 PM EDT by
-
PL/SQL
like to add or change, feel free. PL/SQL, the Procedural Language for SQL, was first introduced with Oracle SQL*Forms 3.0. Subsequently, after
Last updated:
Jun 24 2008, 1:09 PM EDT by
-
Oracle Portal
- it seems that most sites start out using PL/SQL. From Portal 10.1.4, you can also deploy standard JSR-168 Java portlets in Oracle Portal (it takes
Last updated:
Dec 16 2008, 2:41 AM EST by
-
Oracle Forms
, as Oracle Forms uses PL/SQL. Con After Forms 6i, Forms applications need to run web deployed. This has several implications: You need
Last updated:
Jun 13 2008, 4:34 PM EDT by
-
Oracle OLAP Versions
5.0 4.8 Versions 11gR1 - Key Features The OLAP Option to Oracle Database 11g continues the development trends
Last updated:
Jul 10 2008, 12:38 PM EDT by
-
Oracle OLAP Option Background
) purchased MDS. Express was completely rewritten in C 1988 – Oracle Version 6 was released , row-level locking, hot backup and pl/sql. ( src
Last updated:
Jul 10 2008, 12:34 PM EDT by
-
PHP Oracle FAQ
be embedded into HTML pages. PHP is comparable to languages such as JSP (Java Server Pages) and Oracle's PSP (PL/SQL Server Pages
Last updated:
Jun 4 2009, 1:29 PM EDT by
-
Oracle Olap Terminology-C
composite. Version 10g of Oracle OLAP provides a new, internationally patented technology for the AW, which is exposed via a simple check box in AWM
Last updated:
Feb 7 2008, 8:58 AM EST by
-
Oracle OpenWorld Unconference
PeopleSoft 9.x upgrade.(Arvind Rajan, Astute Business Solutions) Overlook III: Oracle Application Express Test Drive for DBAs and PL/SQL Developers ( Lead
Last updated:
Jun 3 2009, 6:06 PM EDT by
-
SQL Dev SDK:How To create a muliselect nodes action
and simplifies database development tasks. Using Oracle SQL Developer, users can browse database objects, run SQL statements, edit and debug PL/SQL
Keyword tags:
None
Last updated:
Aug 6 2008, 11:23 AM EDT by
-
What's New in Oracle Database 11g Release 11.1 Oracle OLAP (Part 1)
What's New in Oracle Database 11g Release 11.1 Oracle OLAP? (Part 1)
This preface identifies the major enhancements to the OLAP option of Oracle Database.
Oracle Database 11g Release 11.1 Oracle OLAP
The OLAP Option to Oracle Database 11g continues the development trends of Oracle9i and Oracle Database 10g, especially in deepening integration with the database and enhancing SQL access to cubes, security, and metadata. The power of OLAP is easily accessible to SQL applications. Oracle Database 11g also introduces the cube as a summary management solution for relational OLAP (ROLAP) implementations.
OLAP Metadata Integration
All metadata for cubes and dimensions is stored in the Oracle database and revealed in the data dictionary views, so that you can query the entire business model in SQL. Use of the data dictionary to store the metadata officially codifies the dimensional model in the database, provides significant improvements for metadata queries, and supports other new features such as SQL object security for cubes and dimensions.
Automatic Maintenance of Cube and Dimension Views
Oracle Database 11g automatically creates and maintains relational views for every cube, dimension, and hierarchy in the database. If you modify a dimensional object, such as adding a calculated measure to a cube, the view is immediately re-created to reflect the change. Oracle Database defines these views using the new CUBE_TABLE function, which enables the SQL Optimizer enhancements.
Cube Scripts
A cube script is an ordered list of commands that prepare a cube for querying, such as Clear Data, Load Data, Aggregate, Execute PL/SQL, and Execute OLAP DML. For many applications, cube scripts will eliminate the need to use procedural programs for processing cubes.
See "What's New in Oracle Database 11g Release 11.1 Oracle OLAP (Part 2)".
Keyword tags:
None
Posted:
Sep 18 2008, 6:38 AM EDT by
-
Favourite Articles
stored procedures, step by step. More on Oracle Database 11g : New PL/SQL features in 11G touched upon by Tom Kyte : PL/Scope and DBMS_SQL's ability
Last updated:
Jul 10 2008, 7:33 PM EDT by meuwiskl
-
Database Troubleshooting
architecture, memory management, data management, transactions, schema objects, various features, SQL, PL/SQL etc. Everybody working with Oracle database
Last updated:
Apr 8 2008, 3:19 AM EDT by
-
ADF Business Components Examples
) Counting Changed Rows (Inserts, Updates, Deletes) in the Current Transaction ( Steve Muench ) New 11g Feature: Default Configuration ( Steve Muench
Last updated:
Thursday, 1:45 AM EDT by
-
OCA
Raja, I think its wonderful you are interested in joining the ranks by becoming OCA.The Oracle Certified Associate (OCA) credential is typically the first step toward achieving the Oracle Certified Professional and Oracle Certified Master certification. The OCA credential ensures that the individual is equipped with fundamental skills, providing a strong foundation for supporting Oracle products.
I'm assuming you are interested in the database administrator certification patch. You can choose from Oracle9i, Oracle 10g, and now the Oracle 11g paths. If you are interested in become and OCA in Oracle Database 10g, you will need to take racle Database 10g: Administration I: 1Z0-042 exam. The focus of the exam will be solely on Oracle Database 10g Release 2 and the New Features. There are several different avenues to prepare. You can take the Oracle Database 10g: ministration Workshop1 offered by Oracle University, purchase the Self Study CD Course (NETg Oracle), or buy one of the Oracle Certification Exam books offered by Oracle Press at a bookstore. I have found www.bookpool.com to have some of the best prices for the material. No matter which direction you want to take, its best for you to already have experience as an Oracle DBA on 10gR2. Oracle has some practice exams as well on their website.
Check out http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=143 for more information on becoming certified and what topics are covered in the exams.
Good luck!
Reply to thread:
OCA
(6 replies)
Posted:
Apr 28 2008, 9:10 PM EDT by
-
Why not EJBs?
Well, if you look in to JDeveloper 11g evolution, form Tp1 to Tp4, you will notice:
1. In TP1-TP2, EJBs were technology choice in Fusion Application stack.
2. In TP1-TP2, EJBs support was much improved (data controls, bindings, wizards...) compared to 10g. For me it was clearly visible that Oracle is investing in EJBs as well as into EclipseLink.
3. After TP3, BCs are again put in the middle again (Fusion dev stack now again is ADF RC + BCs). EJBs support was staled – no new wizards, empty placeholders in wizards for EJBs etc.
Coinciding with Oracles numerous acquisitions (BEA WebLogic), latency in Fusion AS 11g production (migration of old PL/SQL code to true ADF RC multitier Web UI), I beleive they decided to drop EJBs as platform for porting 11g (as it is much easier with BCs when you have a lot of legacy PL/SQL code and SPs). While EJB 3.1 and JPA 2.0 is much advanced and Java-friendly that BCs, they decided to postpone support for EJBs in R1 (both Fusion 11g AS and JDev 11g) as they don't need them right now and they will be ready when new standards are in place (they will got some breathing space with just porting UI to ADF RC while middle-tier is good enough even on BCs).
Regarding declarative validation, please note that JPA 2.0 will support Bean Validation annotations (JSR-303). So, BCs declarative validation is nothing special and is much simplified compared to JSR-303.
So, if we neglect Oracles emotive relation to BCs as well as pragmatic reasons (hurry to deliver new, fancy, Rich UI to their apps), the future of EJBs is much brighter than BCs. You can promote ADF Methodology with BCs is focus, but you will make a bad influence on many developers which will go that way and learn (in year or two) that there is something much better out there (named EJBs, in core of JEE 6 coming next year).
Posted:
Jul 14 2008, 2:33 PM EDT by
|
|
