oracle codes

Oracle Stored Proc to Return a Recordset (Oracle Side)

Oracle Stored Proc to Return a Recordset (.Net Side)

Oracle DateTime Interval

Change password in Oracle

Doblar comillas simples (escapar para Oracle y Sybase)

List all Stored Procedures in an Oracle Database

Simple Technique to Subtract Years from an Oracle Date

Strip(i.e. remove) special character(s)

Get Columns and Comments (Oracle)

Get a list of all the user tables (Oracle)

Generate the SQL necessary to create sequences for every table (Oracle)

Generate the SQL necessary to create triggers (Oracle)

Copy table into a new table

Convert an Oracle SQL DATE to a STRING in the form CCYYMMDD

OAF - Retrieve a Region/Page from Oracle MDS

OAF - Controller Code to create Javascript popup window

Efficiently compare columns from two tables

Oracle Cursor Query

Selecting a Random Row From Oracle

Oracle SQL - Select OAF File version history

Kill locked session

Drop all tables in Oracle

Drop sequences in current schema

Kill oracle session

Oracle TO_DATE function

Create new Oracle user

Kill all sessions from host in Oracle

Hold concurrent requests by name

Oracle BDB Maven repository

LoneDatabaseClass

Ranking Function - Range over partition - Oracle Analytical function

Oracle - Overlaps function

How to avoid double counting

Regular expression to convert alphanumeric field into numeric field

Oracle TimeStamp to Char conversion

Create/ View/ Delete DB Links in oracle

Push_subq Oracle hint - Execute the sub query before the parent query

Oracle Sequence

Logic to subtract months from a date field and extract run_yr_mo

Variable Declaration Using Database Objects %rowtype

Dynamic SQL - Stored procedure

Return Database Version

Generate HASH Value for a string

Elapsed Time Calculation & SLEEP

Cursor FOR LOOP

Update da table a table

View active sessions in Oracle

Oracle Applications - Find Application (Module) Long Name from Short name

SAS Oracle Bulk Load

Conexión manual a Base de Datos ORACLE

Get all tables and views having this field in their structure

Compare dates in Business Objects Data Integrator with Oracle

Return a random sample of 5% of records of a table with Oracle

Restart Oracle - Ubuntu

Test String is numeric

Oracle - Iterating Cursor

Cambiare tipo in colonna ORACLE

Oracle Application - List Responsibilities and Responsibility Keys that are assigned to a user

Oracle - sql to find what responsibility can run a request / report

Strategy to identify duplicates in an ETL context (for example)

Oracle - Find all responsibilities and concurrent program names based on the executable Name

Oracle - compile report / compile forms on linux

Connect string for Oracle with sqlplus

Oracle - Find which users have FND Diagnostic profile value set

Oracle SQL - get a list of most recent user logins

Query to find Parameters and Value Sets associated with a Concurrent Program

Oracle - get concurrent program runtime / eval performance

Oracle AP-SLA-GL Link Query

Search DDL (stored procedures, functions, etc) for keywords

Oracle Find Profile Values for User

Mover de TableSpace un Objeto o tabla

Retornar Cursor Oracle para Java

Recoger Cursor de Oracle en Java

Borra archivos LOG Oracle usando RMAN

Consultar el MB los tamaños y porcentaje libre de TableSpace Oracle

Mostrar Objetos que hacen Referencia a un Objeto Especifico

Creacion de DBLINK con Full name service

Grant y Revoke sobre objetos - dinamico

Ver tablas asignadas a un usuario por privilegios

Connecting to Oracle using Java JDBC

CASE statement to transpose rows in to columns

List locked object Oracle Database

Advanced Java mysql,oracle,... connect, full functions

Install oracle-java one-liner

Find a blocking session and kill it

Get all procedures from Oracle packages

Oracle TO_DATE Examples

Oracle TO_CHAR Examples

Oracle CONCAT Function

Oracle NVL2 Function

Oracle LISTAGG Function with Examples

Oracle LEAST Function

Oracle GREATEST Function

Oracle REPLACE Function

Oracle CASE Expression

Oracle RTRIM Function

Oracle INSTR Function

Oracle LTRIM Function

Oracle LENGTH Function

Oracle RPAD Function