Oracle Data Pump

Oracle Data Pump

Index

1. Overview of Oracle Data Pump
2. Data Pump Export
3. Data Pump Import

4. Data Pump Legacy Mode

5. Data Pump Performance

6. The Data Pump API

Oracle WebLogic Server 12c (12.2.1): Administration

Oracle WebLogic Server 12c: Administrstion

Index

1. Introduction to Oracle WebLogic Server 12c (12.2.1)
2. Oracle WebLogic Server 12c (12.2.1) Installation in OEL 5.7
3. Oracle WebLogic Server 12c (12.2.1) A New Domain Creation

4. Oracle WebLogic Server 12c (12.2.1): Creation and Configuration Machines

#. Continue

Oracle Data Guard Administration

Oracle Data Guard Administrstion

Index

1. Introduction to Oracle Data Guard
2. Physical Standby Database Creation by SQL and RMAN commands
3. Introduction to Data Guard Broker

4. Data Guard Broker Configuration

5. Physical Standby Database Creation by Enterprise Manager

6. Logical Standby Database Creation

7. Snapshot Standby Database Creation and Management

8. Oracle Active Data Guard

9. Data Protection Mode Configuration

10. Perform Switchover

11. Flashback Database in Data Guard Configuration

12. Enable Fast-Start Failover

#. Continue

Oracle Real Application Cluster

Oracle Real Application Cluster

Index

1. Installation: Grid Infrastructure for a Standalone Server
2. [INS-20802] Grid Infrastructure configuration failed
3....
3. Continue

PL/SQL Scripting - 1 : Display "Hello, World!"

//* Display Hello World*//

Scripts:
--------

DECLARE
 message VARCHAR2(100);
BEGIN
 meassage := 'Hello, World!';
 DBMS_OUTPUT.PUT_LINE(message);
END;
/

Output:

--------

SQL> @helloworld.sql

PL/SQL procedure successfully completed.

It is not showing "Hello, World!" on the screen.

Second Try:

--------------

Set your server output on and execute the script.

Example is given below -

SQL> set serveroutput on

SQL> @helloworld.sql

Hello, World!

PL/SQL procedure successfully completed.

***SUVARAMB***

ADRCI: ADR Command Interpreter

ADRCI: ADR Command Interpreter

Index:

1. About the ADRCI

2. Definitions
3. Starting and Using the ADRCI and Getting Help

4. Setting the ADRCI Homepath Before Using ADRCI Commands

5. Viewing the Alert Log

6. Finding Trace Files

7. Viewing Incidents

8. Packaging Incidents

9. ADR Subdirectories

10. ADRCI Shortcuts
11. ADRCI Command Reference
12. Troubleshooting ADRCI