Oracle Database

Which perform faster in Oracle Database IN or EXISTS

What is the difference between CLOB and BFile in Oracle Database

What is the difference between implicit and explicit cursor in Oracle Database

What is the difference between truncate and delete in Oracle Database

What is the DUAL table in Oracle Database

What is Anonymous PL/SQL block in Oracle

Oracle Express Edition XE-11gr2 Screen Shorts

How to perform a character wise replacement of a string in Oracle

How To Extract Some Characters From A String In Oracle

How to Replace a String Characters with another Set of Characters in Oracle

How to remove characters from the right side of a text expression in Oracle

How to remove characters from the left side of a text expression in Oracle

How to insert characters in the right side of a string in oracle

How to insert characters in the left side of a string in oracle

How to convert a string from lowercase to uppercase in oracle

How to convert a string from uppercase to lowercase in oracle

How to calculate length of a string in oracle

How to convert a String first character in uppercase in oracle

How to concatenate two strings in Oracle

How to get value of N specified character in Oracle

How to get the ASCII value of first character in Oracle

Oracle User Creation and Management

Creating Views in Oracle Database Using TOAD

Create Tables in Oracle Database using TOAD

Proper Steps to Uninstall Oracle Database in Window XP


Oracle 11g Release 2, New Features for DBA

Install Oracle 11g Release 2 Single Environment (Images)

Oracle Database 11gR2 Grid Infrastructure and Automatic Storage Management for a Standalone Server (Part-2)

Oracle Database 11gR2 Grid Infrastructure and Automatic Storage Management for a Standalone Server (Part-1)

Configure, Monitor and Use Oracle Database 11g Flashback

Oracle Database 11g - Tablespace

Oracle Database 11g Recovery Manager (RMAN)

11g DBA Basic Examples

Oracle Database 11g Gata Guard Manual Switch Over on Linux

Oracle Database 11g Data Guard Configuration on Linux

Installation of Oracle 11g on SUSE Linux Enterprise Server 11

Common Questions of Oracle DBA asked during interview

How to Show Used/Free Tablespace Space in Oracle DB

Show Used/Free Space Datafile wise in Oracle DB

Find the Overall DB Size in oracle Database

Monitoring DML Operations on the Tables

Important Oracle Scripts for Database Administrators (Part-2)

Important Oracle Scripts for Database Administrators (Part-1)

Find Used Size in a table

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

Image
Oracle Integration Cloud Service (ICS) is a solution that enables you to simplify integrations between cloud applications, and between cloud and on premises applications. It helps you create connections to well-known and less-known SaaS and PaaS applications, using the available cloud adapters, publish or subscribe to the Messaging Cloud Service, or use industry standards such as SOAP, REST, FTP, File, and JMS. For more information watch this Oracle video.
Read more

How to Create Packages in Oracle Database using TOAD for Oracle

Image
What are Packages in Oracle Database A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification and Package Body. Package Specification Package Specification acts as an interface to the package. Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Package specification does not contain any code. Package Body Package body is used to provide implementation for the subprograms, queries for the cursors declared in the package specification.
Read more

How to create a Simple Scheduler Job in Oracle Database using Toad

Image
Scheduler is a process which runs programmed jobs at scheduled times. This process wakes up at the specified time and runs automatically. The basic elements of the scheduler are: Jobs Schedules Programs A job specifies what needs to be executed and when. A program is a collection of metadata that will be executed by the scheduler. It contains the name of the program (a procedure or an executable, the type of the program (pl/sql block, shell script etc). A schedule specifies when and how many times a job is executed. 1. Login to the database using Toad, and create a Scheduler Job as follows;
Read more