oracle codes

Oracle TO_CHAR Examples

Oracle TO_DATE Examples

Get all procedures from Oracle packages

Find a blocking session and kill it

Install oracle-java one-liner

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

List locked object Oracle Database

CASE statement to transpose rows in to columns

Connecting to Oracle using Java JDBC

Ver tablas asignadas a un usuario por privilegios

Grant y Revoke sobre objetos - dinamico

Creacion de DBLINK con Full name service

Mostrar Objetos que hacen Referencia a un Objeto Especifico

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

Borra archivos LOG Oracle usando RMAN

Recoger Cursor de Oracle en Java

Retornar Cursor Oracle para Java

Mover de TableSpace un Objeto o tabla

Oracle Find Profile Values for User

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

Oracle AP-SLA-GL Link Query

Oracle - get concurrent program runtime / eval performance

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

Oracle SQL - get a list of most recent user logins

Oracle - Find which users have FND Diagnostic profile value set

Oracle - compile report / compile forms on linux

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

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

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

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

Cambiare tipo in colonna ORACLE

Oracle - Iterating Cursor

Test String is numeric

Restart Oracle - Ubuntu

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

Compare dates in Business Objects Data Integrator with Oracle

Get all tables and views having this field in their structure

SAS Oracle Bulk Load

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

View active sessions in Oracle

Update da table a table

Elapsed Time Calculation & SLEEP

Return Database Version

Logic to subtract months from a date field and extract run_yr_mo

Oracle Sequence

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

Create/ View/ Delete DB Links in oracle

Oracle TimeStamp to Char conversion

Regular expression to convert alphanumeric field into numeric field

Oracle - Overlaps function

Ranking Function - Range over partition - Oracle Analytical function

LoneDatabaseClass

module operator in oracle sql