Tag : Oracle

Title User Language Tags Description Date
PL/SQL Elapsed time geekzspot PL/SQL

Calculate and display the elapsed time for PL/SQL code

 October 19
Search all PL/SQL geekzspot SQL

Search all Oracle Database PLSQL Stored Procedures and Functions database code for a string

 October 12
Search all Oracle columns geekzspot SQL

Search all the database Tables for column names that contain a string

 October 12
Mover de TableSpace un Objeto o tabla thescorpion PL/SQL

comando para cambiar el tablespace de un objeto

 September 21
Search DDL (stored procedures, functions, etc) for keywords jstrawther SQL

Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.

 April 5, 2012
Oracle AP-SLA-GL Link Query theonlyalterego SQL

AP-SLA-GL Link Query

 January 21, 2012
Oracle - get concurrent program runtime / eval performance theonlyalterego SQL

can be used to track Oracle Apps concurrent program performance

 January 21, 2012
Oracle SQL - get a list of most recent user logins theonlyalterego SQL

Query to find the most recent logins for a particular user ( find 1 years worth )

 December 23, 2011
Connect string for Oracle with sqlplus blackthorne SQL October 11, 2011
test snippet 2 mariolassnig SQL June 30, 2011
Oracle - sql to find what responsibility can run a request / report theonlyalterego SQL

Very useful sql to find which responsibility has access to a report or request.

 June 24, 2011
Oracle - Iterating Cursor Hisoka PL/SQL

this code is for iterating through a cursor

 April 23, 2011
Test String is numeric marvin9000 SQL April 1, 2011
Restart Oracle - Ubuntu JohnnyGamba Bash March 6, 2011
Return a random sample of 5% of records of a table with Oracle xavsio4 SQL January 28, 2011