The social network for Oracle people

All Blog Posts (734)

Top 10 Features in Oracle 11g for Developers

Dear All,

Recently, I got an opportunity to present a oracle session on Top 10 Features in Oracle 11g for Developers.

I am attaching the presentation here. Hope you find it useful.

Thanks,

Vijay

Top10_Features_Oracle11g.pdf

Added by Vijay Mahawar on May 21, 2012 at 1:26am — No Comments

Oracle Table Redefinition

http://blog.canbakal.com/2012/05/20/oracle-table-redefinition/

Added by Bugra Canbakal on May 20, 2012 at 3:00am — No Comments

Attend COLLABORATE12 Virtually for half the price - Don't miss the action - Register NOW!

Only $99

Special Registration Code : COLLAB12

Registration URL:

http://events.ioug.org/e/in/eid=28

Sign Up,…

Continue

Added by Tariq Farooq on April 22, 2012 at 11:24pm — No Comments

Learn what Business Intelligence is - A new book on Oracle Business Intelligence (OBIEE)

Book Title: Implement Oracle Business Intelligence (Volume 1)

Analyze the Past – Streamline the Present – Control the Future

In today's fast paced technology-driven world, successful businesses depend heavily on driving intelligent decisions based on latest information. More informed decisions mean more revenue, less risk, decreased cost, and improved operational control.…

Continue

Added by Riaz Ahmed on April 11, 2012 at 10:09pm — No Comments

Hands-On Tutorial Book on Oracle Application Express for Novices

Book Title: Create Rapid Web Applications Using Oracle Application Express (APEX)

A practical guide for novice and intermediate users to rapidly develop professional web applications.

In this fast paced technological age, where things change rapidly, no one has the time to go through lengthy concept books just to assess what the technology has for them. As an IT professional, I too prefer concise practical…

Continue

Added by Riaz Ahmed on April 11, 2012 at 10:00pm — No Comments

Materialized Views & Partition Change Tracking

http://uhesse.com/2012/04/05/materialized-views-partition-change-tracking/

Added by Uwe Hesse on April 11, 2012 at 4:46am — No Comments

Auditing for Physical Standby Databases with Real-Time Query

/http://uhesse.com/2012/03/28/auditing-for-physical-standby-databases-with-real-time-query/

Added by Uwe Hesse on April 11, 2012 at 4:45am — No Comments

SQL CHECK Constraint on CREATE TABLE

To allow naming of a CHECK constraint, and for defining a CHECK constraint on multiple columns, use the following SQL syntax:

MySQL / SQL Server / Oracle / MS Access:

CREATE TABLE Persons

(P_Id int NOT NULL,

LastName varchar(255) NOT NULL,

FirstName varchar(255),

Address varchar(255),

City varchar(255),

CONSTRAINT chk_Person CHECK (P_Id>0 AND…

Continue

Added by Caesar Oladipo Komolafe on April 9, 2012 at 10:00am — No Comments

Don't let #COLLABORATE12 slip away - Register NOW with special Virtualization SIG Registration Code: http://bit.ly/HcTGOM

Don’t let COLLABORATE12 slip away – Register NOW!…

Continue

Added by Tariq Farooq on April 3, 2012 at 5:20pm — No Comments

SQL SELECT TOP Equivalent in MySQL and Oracle

MySQL Syntax

SELECT column_name(s)

FROM table_name

LIMIT number

Example

SELECT *

FROM Persons

LIMIT 5

Oracle Syntax

SELECT…

Continue

Added by Caesar Oladipo Komolafe on April 3, 2012 at 3:03pm — No Comments

Combining AND & OR

You can also combine AND and OR (use parenthesis to form complex expressions).

Now we want to select only the persons with the last name equal to "Svendson" AND the first name equal to "Tove" OR to "Ola":

We use the following SELECT statement:

SELECT * FROM Persons WHERE
LastName='Svendson'
AND (FirstName='Tove' OR FirstName='Ola')

Added by Caesar Oladipo Komolafe on April 3, 2012 at 3:00pm — No Comments

Installing the 12c Agent fails with the following error

-e Validating the OMS_HOST & EM_UPLOAD_PORT

Executing command : /scratch/aime/Agent19/core/12.1.0.1.0/jdk/bin/java

-classpath

/scratch/aime/Agent19/core/12.1.0.1.0/jlib/agentInstaller.jar:/scratch/aime/Ag

ent19/core/12.1.0.1.0/oui/jlib/OraInstaller.jar

oracle.sysman.agent.installer.AgentInstaller

/scratch/aime/Agent19/core/12.1.0.1.0 /scratch/aime/SHIP0919

/scratch/aime/Agent19…

Continue

Added by Muhammad Atif Akram on March 28, 2012 at 12:33am — No Comments

Oracle10g 11g DBA Online Training With Placement By Newyorksys

Welcoming OPT/ CPT/ H1B/ GC/ Citizens (Fresher and experienced) professionals for our consulting needs.

Online Training (Remote Training + Real-time exp) / In-Class Training available

About Us:

NewyorkSys is one of the leading top Training and Consulting Company in US, with a good placement track record. We have certified trainers. We will provide Online Training, Fast Track online training, with job assistance.

We are providing excellent Training in all courses. Faculty…

Continue

Added by Newyorksys on March 27, 2012 at 1:13am — No Comments

Recover a Lost Datafile with No Backup

CONNECT WITH RMAN

C:\>RMAN TARGET /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Feb 29 13:36:14 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1304302012)

CHECK IT OUT DO YOU HAVE ANY BACKUP ??

RMAN> LIST BACKUP…

Continue

Added by Rohit Khurana on March 17, 2012 at 4:30am — No Comments

AROUG Borns

The february 16, 2012 borns the Argentinian Oracle User Group AROUG. In a new edition of Oracle Developers Day 2012 in Buenos Aires, a group of argentinian members of Comunidad Oracle Hispana, decided transform a long time idea in reality. Marcelo Burgos, Fernando Garcia, Marcelo Ochoa and Gerardo Tezza go your first steps. Days after, Clarisa Maman Orfali and Gustavo Gonzalez join the group.…

Continue

Added by Marcelo Burgos on March 16, 2012 at 8:24pm — 1 Comment

Latch Nedir Ve Latch Contention Sebepleri

Latch Nedir?

Latch SGA içerisindeki shared data yapısını korumak amacıyla ile geliştirilmiş düşük seviyeli seri data erişim mekanizmasıdır.Yani prosesiın SGA içerisinde memory parçasının tutmmasıdır.Proses bittiğinde ise ilgili latch başka bir prosese verilir. Latch İşletim sisteminden bağımsız değildir. Çünkü bir prosesin ne zaman biteceği ve ne kadar süreceği işletim sistemine bağlıdır.

Latch bir çeşit lock dır.Şöyleki bir den çok kod…

Continue

Added by Özcan YILDIRIM on March 14, 2012 at 2:28pm — No Comments

Trial Version of LongBridge Java Bean, now available on WEB

http://lbridge5.wordpress.com/2012/02/13/tv/

Added by LongBridge Corporation on March 6, 2012 at 8:33pm — No Comments

Trial Version of LongBridge Java Bean, now available on WEB

Added by LongBridge Corporation on March 6, 2012 at 8:32pm — No Comments

I present to you my book “Oracle Database 11g R2″ in Turkish…

In this book you can find chapters from installation of Oracle Database 11g R2 to configuration and from configuration to management. I would like to share with you a comprehensive manner.

Every day, the utilization rate for the ORACLE database is increasing . My greatest goal in this book is to increase the number of sources in Turkish. And contribute to my colleagues who want to educate yourself about ORACLE Database.

The best method of learning is practical learning. With…

Continue

Added by Talip Hakan Ozturk on March 5, 2012 at 1:30pm — No Comments

Auto Restart Enterprise Manager Cloud Control Agent 12c;

Introduction:

Oracle Restart is a component added to the 11gR2 in order to improve the high availability of different database resources.

Database instances, listeners are resources that can be automatically restarted after a hardware or software failure or whenever the server host restarts.

These components can be easily added to the Oracle Restart using the crsctl add command.

In this article, I am going to show you how to add the Enterprise…

Continue

Added by Wissem EL KHLIFI on March 5, 2012 at 2:46am — No Comments