List Beach Resorts Chennai

Uninstall Oracle 10G on Windows XP

These are the steps to take after deleting from Oracle Universal Installer:

# Stop all Oracle services that may still turn.

Start-> Settings-> Control Panel-> Services

Look at every service that starts with "Oracle" and stop it.

Run # Run the string from regedit and delete the following keys (Some of these may have different names):

HKEY_CURRENT_USER \\ SOFTWARE \\ ORACLE

HKEY_LOCAL_MACHINE \\ SOFTWARE \\ ORACLE

HKEY_LOCAL_MACHINE \\ SYSTEM \\ CurrentControlSet Services \\ EventLog \\ Application \\ Oracle.oracle

HKEY_LOCAL_MACHINE \\ SYSTEM \\ CurrentControlSet Services \\ OracleDBConsole

HKEY_LOCAL_MACHINE \\ SYSTEM \\ CurrentControlSet Services \\ Oracle10g_home

HKEY_LOCAL_MACHINE \\ SYSTEM \\ CurrentControlSet Services \\ OraclService

# Delete the Oracle home directory

C: \\ Oracle # Delete the Oracle

from the Program Files directory:

C: \\ Program Files \\ Oracle

Oracle # Delete the shortcut from the Start Menu:

C: \\ Documents and Settings \\ All Users \\ Start Menu \\ Programs \\ Oracle *

# Remove all Oracle from PATH variable. Go here:

Start-> Settings-> Control Panel-> System-> Advanced-> Environment Variables

# Delete Oracle.DataAccess Polic.Oracle of each and every file from the GAC, which is here:

C: \\ Windows \\ assembly \\

Recent Developments Of Empysema

Package

To see the body of our package we have to check first that we installed version of Oracle.

If it is equal to or later versions to exploit the package just nine native dbms_metadata. With this query we get what we want:

SQL> select dbms_metadata.get_ddl ('PACKAGE', '') from dual;

If we need to versions prior to nine use tables all_source:

SQL> desc all_source;

Name Null?

Type --------------------------------- -------- ---- ---------------------------------------------

OWNER VARCHAR2 (30)

NAME VARCHAR2 (30)

TYPE VARCHAR2 (12)

LINE NUMBER

TEXT VARCHAR2 (4000)

and make this query if you want the definition of the package:

SELECT text FROM

all_source

WHERE owner = 'OWNER_PACKAGE '

AND name = 'NOME_PACKAGE ' AND type =

'PACKAGE' ORDER BY

type, line;

and this also if you want the body:

SELECT text FROM

all_source

WHERE owner = 'OWNER_PACKAGE' AND name =

'NOME_PACKAGE'

AND type = 'PACKAGE BODY' ORDER BY

type, line;

You can look at the description of the package simply laciando function desc:

SQL> desc OWNER_PACKAGE.NOME_PACKAGE;