GAHZLY

The first of the Oracle 12c certification exams to go into production is 1Z0-061: Oracle Database 12c: SQL Fundamentals. Oracle University put this exam into production almost simultaneously with the retirement of the much older exam 1Z0-007: Introduction to Oracle9i SQL. However, the 11g version of the SQL Fundamentals exam, 1Z0-051, is still available. Having two equivalent exams in production leads to a fair amount of confusion among certification candidates. In this article I will discuss the two exams, what is different between them, and how to choose one over the other. Either will satisfy the SQL requirement for the “Oracle Database 11g Administrator Certified Associate” or “Oracle PL/SQL Developer Certified Associate” tracks. The SQL requirement can also be satisfied by passing 1Z0-047: Oracle Database SQL Expert. However, 1Z0-047 is a considerably harder exam than either 1Z0-051 or 1Z0-061. This is an option that should only be considered if you have wo...

Passing the Oracle Database 12c: Essentials exam (1Z0-497) will earn exam candidates the Oracle Database 12c Certified Implementation Specialist certification. It will also make them an OPN Certified Specialist in Oracle 12c if they are employed by a company that is part of the Oracle Partner Network (OPN). Partner companies with employees who are certified as OPN specialists gain a higher level of specialization in the OPN program. As such, this credential makes you a more attractive employee to companies that are part of the Oracle Partner Network. The 1Z0-497 exam is a standalone test and is not part of any track. To earn the related certification requires only passing the exam. There is no required training or other pre-requisites. The 12c database will be Oracle’s flagship product for several years to come and this exam will be a popular one for some time. This exam covers many of the same topics as the 12c database administrator track but does not require the same depth of...

Oracle Warehouse Builder (OWB) Release 11g is included in all Oracle Database 11g installations. OWB is Oracle’s tool for metadata and data management. OWB also provides data quality, ETL, dimensional modeling, and data auditing. I recently installed the Oracle Database 11g on my computer which runs Microsoft Vista. I was in the process of running the Repository Assistant of OWB and at the installation stage of 76% completion; I received the following error message: The Warehouse Builder workspace owner installation failed on user OWBSYS. Exception occurred in ‘processSPAWN’.java’lang.Exception: Error: java.sql.SQLException: ORA-29532 : Java call terminated by uncaught Java exception: java.sqlSQLException: OWBSYS is not granted access to c:\oracle\product\11.1.0\db_1\/owb/bin/admin/rtrepos.propterties: Please run UnifiedRepos/reset_owbcc_home.sql specifying the path of the Oracle Home from which the Control Center Service is being run. At times while installing a...

Oracle Certification announced the retirement of several exams on March 13, including 1Z0-147: Program with PL/SQL . This exam satisfies the PL/SQL component to become a Oracle PL/SQL Developer Certified Associate. Originally developed while Oracle 9i was the current database release, there has been speculation for some time that this exam would be retired. As of the announcement, the exam will no longer be available after July 31, 2013. Oracle professionals that are pursuing the PL/SQL development path have been asking what effect this retirement will have on the process of getting the PL/SQL OCA certification. The impact of the announcement and what actions you should take depend on what stage of the PL/SQL certification process you are in. If you have passed 1Z0-147 — For people who have already passed the test, the exam retirement means nothing at all. Oracle certifications and exam results do not change when an exam is retired. The only people affected by the retirement are ...

Order of Precedence in SQL The importance of order of precedence is most evident when you deal with the grouping of conditions. This is best illustrated in select statements like this: SELECT empno, payrate, dept_code FROM emp_work WHERE dept_code = ‘SALES’ AND payrate = 18 OR payrate = 20; The user is trying to query for information on all the employees in the SALES department who have payrates of either 18 or 20. However the actual results from this query are going to be ALL of the employees in the SALES department with a payrate of 18 and ANY employee with a payrate of 20. This is because Oracle evaluates the ‘AND’ first because of its higher precedence. When Oracle looks at this query it sees: WHERE dept_code = ‘SALES ‘ AND payrate = 18 together and evaluates those conditions first. Oracle looks for employee records where the employee is in the SALES department and has a payrate of 18. THEN Oracle looks at the OR operator, since the first two ...

Among the major international ERP brands, localized for Brazilian market we should mention SAP with its recently localized product: SAP Business One, Oracle: Oracle E-Business Suite/Oracle Financials/Oracle Applications, Microsoft Business Solutions Navision (Microsoft Dynamics NAV) and Axapta (Microsoft Dynamics AX) – Axapta localization is scheduled to be available in 2006. In this small article we will concentrate on Oracle E-Business Suite Brazilian localization highlights and its competition. Oracle Financials: o Standard Functionalities – they automate business processes common in all countries, so these are used Worldwide. Globalization Code ‘JG’ is located in Globalization product ares o Regionalized Code – for Americas it is ‘JL’ o Brazilian Localization – the code is ‘JLBR’ Competition: SAP Business One. When we are talking about mid-size and small companies (10-300 employees), we would like to give some comparis...

The central element in the unfolding of Business Intelligence history is predictive analytics and a shift has been underway in employing this technology among all BI Megavendors. Gartner expects that Big Data will drive $34 billion in IT spending worldwide this year. A Boeing jet generates 10 terabytes of information per engine every 30 minutes of flight, according to Stephen Brobst, the CTO of Teradata. Likewise, it is estimated that the number of devices connected to the Internet– currently 9 billion– will reach 50 billion by the end of the decade. These devices will be churning out heaps of data most of which are unstructured (videos, images, audios). Although Predictive analytics falls under Business Intelligence (some disagree), it is different than traditional BI in that BI embodies reports, visualizations, scorecards, dashboards whereas Predictive analytics uses machine learning algorithms to predict the probability of outcomes. Businesses that adopt predictive analyt...

In this small article we will only concentrate on Microsoft Dynamics Axapta (and will not consider Microsoft Dynamics GP and NAV) in comparison to Oracle Financials/E-Business Suite/Applications and the localization and implementation in Latin America and Brazil. o Architecture & Lifecycle. In our opinion each ERP/MRP package should be first considered from its architectural fundamentals and the step in its lifecycle. Oracle E-Business Suite should be considered as very matured product and it has traditionally strong positions among corporate clientele. Oracle Applications design is in transition to Oracle Fusion project, however you should probably consider it as rather traditional. Microsoft Axapta/Microsoft Dynamics AX has modern design (very end of XXth century and very beginning of XXI). Axapta is targeted to upper mid-market and it also serves as high-end ERP for large corporations. Having modern design – Axapta has potential to be sold and increase its market share just...