Easy XML - a Programming Oriented Approach
In a previous article I talked about using Natural Oracle Features to get XML data out of an Oracle database, and put data into an Oracle database, without actually having to learn a lot about XML related technologies. Still, there are many who continue to resist using OBJECTS, COLLECTIONS, and INSTEAD-OF-TRIGGERS in their daily work with the Oracle RDBMS. Since the biggest hurdle with XML seems to be parsing it into its component data elements, here is a more programming oriented approach to parsing XML data inside Oracle that should make this crowd happy. read more Manually DB Creation with 11G
Manually database creation is one of the more frequently performed actions of a professional DBA. And, with Oracle 11g it only takes a few minutes to do :)
The procedure is same as previous which we are used for 9i and 10g.
In this database creation I used below features:
1. OMF (Oracle Managed File) for datafiles, redolog files & controlfiles
2. FRA (Flash Recovery Area) for Archivelog or backup files
3. ASM (Automatic Storage Mgmt) for Volume manager
1. Create Required Directories
E:\>mkdir e:\oracle\ORA11G
read more Why I Choose Oracle as My Career?
There are some question which asked frequently on forums from every oracle newbie.
1. Which Oracle Certification I choose ?
Here I will explain in details.
There types of Oracle Certification we can do.
1. Oracle DBA
2. Oracle Developer
3. Oracle Application DBA
1. Oracle DBA
The person which maintain Oracle Database called Oracle Database Administrator.
There are some frequent work for Oracle DBA
1. Database Backup Responsibity.
2. Database Performance Tunning
3. Database Basic Administration Like " user creation, database security"
read more How to compile Invalid Object?
There are five ways to recompile invalid objects in schema.
1. DBMS_DDL
2. DBMS_UTILITY
3. UTL_RECOMP
4. UTLRP.SQL
5. Manually Recompile
Definition
This procedure is equivalent to the following SQL statement:
ALTER PROCEDUREFUNCTIONPACKAGE [.] COMPILE [BODY]
[code]
Syntax
Exec dbms_ddl.alter_compile ( type , schema, name);
Type : Must be either PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY or TRIGGER.
Schema : Database Username
Name : Objects name
Example
read more Migrating Databases From NON-ASM to ASM
Dear Friends,
In this article we focus on How to migrate existing database to ASM.
Step:1
Login to SYSDBA user and alter below three parameter for controlfile,datafile or FRA location with SPFILE option.
1. First need to set below parameter for controlfile,datafile or FRA.
NOTE: I have two disk group here I am using "DGRP2" disk group.
[code]
SQL> alter system set control_files='+DGRP2' scope=spfile;
System altered.
SQL> alter system set db_create_file_dest='+DGRP2' scope=spfile;
System altered.
read more Pl/Sql Server Pages
Oracle PL/SQL Server Pages (PSP) is Oracle's PL/SQL dynamic server-side scripting solution for Web application development. Oracle PSP includes the PL/SQL Server Pages Compiler and the PL/SQL Web Toolkit. Oracle PSP enables PL/SQL users to develop Web pages with dynamic content by embedding PL/SQL scripts in HTML. PSPs separate application logic (embedded PL/SQL scripts) from the layout logic (HTML) making the development and maintenance of PL/SQL Server Pages easy. read more OCA Oracle Database 11g: Administration I Exam Guide
Beginning PL/SQL: From Novice to Professional (Beginning from Novice to Professional)
Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales' extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features. read more Sun Certified Web Component Developer Study Guide (Exams 310-081 & 310-082) (Oracle Press)
An integrated study system based on proven instructional methodology, this book and CD package shows you not only what--but how--to study for the SCWCD exam. The book offers complete coverage of all official exam objectives, 190+ practice exam questions, step-by-step exercises, on-the-job elements, and chapter self-tests. The CD-ROM contains MasterExam software with a complete 69-question exam, a searchable electronic book, 45+ complete web applications with source, and access to a downloadable bonus exam (with free online registration). Oracle 10g Developer: PL/SQL Programming
Learn how to use the PL/SQL programming language effectively, using one of the most popular and widely-used software programs in large companies today. Oracle 10g Developer: PL/SQL Programming uses Oracle 10g to provide an overview of the PL/SQL programming language, beginning with fundamental PL/SQL concepts and progressing to the writing and testing of PL/SQL code. The book then progresses to more advanced topics, such as Dynamic SQL and code tuning. Updated to the latest release, Oracle 10g, it uses the developer's perspective to focus on the PL/SQL component of the software. read more
|