Showing posts with label Oracle/PLSQL. Show all posts
Showing posts with label Oracle/PLSQL. Show all posts
Monday, May 19, 2014

Determining NLS_DATE_FORMAT Oracle

›
Oracle >  NLS_DATE_FORMAT NLS_DATE _FORMAT  specifies the default date format to use with the  TO_CHAR  and  TO_DATE  functions Exam...
Tuesday, April 29, 2014

Find last modified tables Oracle

›
Oracle > Scripts USER_TAB_MODIFICATIONS describes modifications to tables owned by the current user that have been modified since th...
Friday, March 21, 2014

Oracle Sequence Example

›
Oracle >  Sequence Sequences are database objects from which multiple users can generate unique integers. The sequence generator gen...
Wednesday, February 26, 2014

Read XMLTYPE Oracle C#

›
C# > Oracle.DataAccess > Read XMLTYPE  An  OracleXmlType  object represents an Oracle  XMLType  instance. Example: OracleCon...
Thursday, February 20, 2014

Oracle DBMS_SCHEDULER

›
Oracle  >    SYS . DBMS_SCHEDULER   The DBMS_SCHEDULER package provides a collection of scheduling functions and procedures. Creat...
Wednesday, February 19, 2014

Oracle create job example

›
Oracle >    SYS . DBMS_SCHEDULER >  CREATE_JOB The   CREATE_JOB  procedure creates a single job. You can create multiple jobs using...
Tuesday, February 18, 2014

Timestamp to date Oracle

›
Oracle > Timestamp > To Date select * from your_table where TO_DATE ( TO_CHAR ( timestamp_date , 'YYYY-MON-DD' ), ...
Wednesday, February 12, 2014

ORA_ROWSCN Oracle example

›
Oracle ORA_ROWSCN returns the conservative upper bound system change number (SCN) of the most recent change to the row. This is useful fo...
Wednesday, November 20, 2013

What is Oracle PL/SQL?

›
Oracle PL/SQL PL/SQL is an language that was designed for processing of SQL commands.  PL/SQL stands for Procedural Language extension o...
Tuesday, November 19, 2013

Get list of all tables in Oracle

›
Oracle > List of all tables See all the tables that your account has access SELECT owner , table_...

Oracle Connection strings

›
Oracle > Connection strings With tnsnames.ora Data Source = OracleDB; User Id = Username; Password =P assword; ...
Monday, November 18, 2013

BLOB (Binary Large Object) Oracle Data Type

›
Oracle > Data Type > BLOB A BLOB (Binary Large Object) can hold up to 4 GB of data. BLOB's are designed for storing digitized i...
Friday, November 8, 2013

Oracle FOR LOOP

›
Oracle > FOR LOOP IN The syntax for the FOR Loop In Oracle is: FOR loop_counter IN [REVERSE] lowest_number..highest_number LOOP ...
Thursday, November 7, 2013

Get Oracle Version

›
Oracle > Version V$VERSION displays version numbers of core library components in the Oracle Database. Example: select * from v$v...
Monday, January 14, 2013

Duplicate rows in Oracle

›
Oracle > Scripts SQL Query to find duplicate rows in Oracle SELECT   * FROM   table_name A WHERE   A . rowid >   ANY...
Friday, February 18, 2011

Extract hour, minute from date column Oracle

›
Oracle > Extract hour, minute from date column SELECT   to_char ( column_date , 'HH24' ) hh   , to_char ( column , 'mi...
Wednesday, September 1, 2010

Null data in Oracle using the ORDER BY clause

›
From: Control null data in Oracle using the ORDER BY clause Date: June 19th, 2007 Author: Bob Watkins NULL data, which is sometimes cal...
Monday, June 7, 2010

Oracle/PLSQL: Instr Function

›
Oracle/PLSQL > Functions > Instr Instr function returns the location of a substring in a string. The syntax for the instr Oracle ...
Monday, May 17, 2010

Oracle/PLSQL: Oracle System Tables

›
Oracle/PLSQL > Oracle System Tables -------------------------------------------------------------------------------- Below is an alph...
Saturday, May 15, 2010

Oracle FOR LOOP

›
The syntax for the FOR Loop in Oracle is: FOR loop_counter IN [REVERSE] lowest_number..highest_number LOOP {.statements.} END LOOP; ...