Thursday, August 31, 2006

How To Series; Creating and Updating Duplicate Databases with RMAN

How To Series; Creating and Updating Duplicate Databases with RMAN

ApEx Series; How to Authenticate and use OID Groups in ApEx Using LDAP Server

ApEx Series; How to Authenticate and use OID Groups in ApEx Using LDAP Server

How To Series; A Method That Guarantees Integrity, the Beauty of Table Encapsulation

How To Series; A Method That Guarantees Integrity, the Beauty of Table Encapsulation

ApEx Series; what port the HTTP server is listening on

ApEx Series; what port the HTTP server is listening on

How To Series; The PL/SQL Code Profiler, the DBMS_PROFILER package

How To Series; The PL/SQL Code Profiler, the DBMS_PROFILER package

How To Series; Number To Words Conversion Function

How To Series; Number To Words Conversion Function)

ApEx Series; How to retrieve Windows IP address(JavaScript)

ApEx Series; How to retrieve Windows IP address(JavaScript)

ApEx Series; AJAX and DHTML with ApEx

ApEx Series; AJAX and DHTML with ApEx

ApEx Series; security API

ApEx Series; security API

How To Series; upper(’i') => ‘İ’, ‘NLS_SORT = XTURKISH’

How To Series; upper(’i') => ‘İ’, ‘NLS_SORT = XTURKISH’

Tuesday, August 29, 2006

How to Series; Trigger Code That Will Insert Seq.NextVal Into A Table After Insert

How to Series; Trigger Code That Will Insert Seq.NextVal Into A Table After Insert

How to Series; Retrieve the Source Code of a Trigger

How to Series; Retrieve the Source Code of a Trigger

How to Series; Retrieve the sid,serial#,username for the current session

How to Series; Retrieve the sid,serial#,username for the current session

How to Series; Determine whether Table Compression Is Enabled

How to Series; Determine whether Table Compression Is Enabled

How to Series; Get the Number of Days Between Two Dates Excluding Holidays

How to Series; Get the Number of Days Between Two Dates Excluding Holidays

How to Series; Use Linefeed or Carriage Return

How to Series; Use Linefeed or Carriage Return

Oracle SQL*NET Performance Tuning

Oracle SQL*NET Performance Tuning

Unique index with null values

Unique index with null values

Difference Between UNION and UNION ALL

Difference Between UNION and UNION ALL

ApEx Series; Top Browsers and Operating Systems

ApEx Series; Top Browsers and Operating Systems

Saturday, August 26, 2006

How To Series; Remove the Default Value from a Column

How To Series; Remove the Default Value from a Column

How To Series; find Time (Hours,Mins,Secs) between 2 Dates

How To Series; find Time (Hours,Mins,Secs) between 2 Dates

How To Series; Another Way of obtaining Last Rows Of A Table Without PL/SQL

How To Series; Another Way of obtaining Last Rows Of A Table Without PL/SQL

How To Series; give datatype to columns with create table as select

How To Series; give datatype to columns with create table as select

How To Series; create a non-standard block size tablespace

How To Series; create a non-standard block size tablespace

How To Series; check that oracle application server is running

How To Series; check that oracle application server is running

10g Series; Exexute an external UNIX Shell Scripts on XE with DBMS_SCHEDULER

10g Series; Exexute an external UNIX Shell Scripts on XE with DBMS_SCHEDULER

10g Series; Pivoting with Model Clause

10g Series; Pivoting with Model Clause

How To Series; generate 7 digit random number

How To Series; generate 7 digit random number

How To Series; find palidromes

How To Series; find palidromes

How To Series; find values of the bind variables used

How To Series; find values of the bind variables used

How To Series; calculate the number of words in a column

How To Series; calculate the number of words in a column

Sunday, August 20, 2006

Execution Mode Options for PL/SQL, Definer or Invoker Rights

Execution Mode Options for PL/SQL, Definer or Invoker Rights

AUTHID CURRENT_USER example

How To Series; View the contents of the STANDARD package

How To Series; View the contents of the STANDARD package(and others also)

How To Series; CLose DbLinks Sample Code PROCEDURE close_links

How To Series; CLose DbLinks Sample Code PROCEDURE close_links

How To Series; Get current database uptime and startup time

How To Series; Get current database uptime and startup time

How To Series; Generate a random date within the year

How To Series; Generate a random date within the year

10g Series; OS Statistics

10g Series; OS Statistics

10g Series; PERFORMANCE TUNING USING ADVISORS AND MANAGEABILITY FEATURES

10g Series; PERFORMANCE TUNING USING ADVISORS AND MANAGEABILITY FEATURES

How To Series; Measure nano seconds

How To Series; Measure nano seconds

How To Series; Calculate time difference in nano seconds, Get_Precise_Time package sample

How To Series; Get IP address, Language, Database name, Client, OS USER, SYS_CONTEXT example

How To Series; Get IP address, Language, Database name, Client, OS USER, SYS_CONTEXT example

Summary table management with Oracle, The Secrets of Materialized Views

Summary table management with Oracle, The Secrets of Materialized Views

How To Series; Get database version, DBMS_DB_VERSION

How To Series; Get database version, DBMS_DB_VERSION

Saturday, August 19, 2006

10g Series; Oracle Names is not supported anymore

10g Series; Oracle Names is not supported anymore

How To Series; Oracle AQ(Advanced Queue) Propagation Example

How To Series; Oracle AQ(Advanced Queue) Propagation Example

How To Series; Get the Date/Time when a table was last updated

How To Series; Get the Date/Time when a table was last updated

How To Series; Organization chart demo with Oracle trees

How To Series; Organization chart demo with Oracle trees

How To Series; Sampling a table's data

How To Series; Sampling a table's data

10g Series; List of New Background Processes

10g Series; List of New Background Processes

Differences Between Oracle on NT and Unix

Differences Between Oracle on NT and Unix

How To Series; List of optimizer parameters, 10053 event example

How To Series; List of optimizer parameters, 10053 event example

10g Series; Automatic statistics are populated during index creation or rebuild

10g Series; Automatic statistics are populated during index creation or rebuild

Unix Series; Processing trace on the fly using pipes

Unix Series; Processing trace on the fly using pipes

9i Series; Native XMLType and XMLDB Sample

9i Series; Native XMLType and XMLDB Sample

How To Series; List of the internal event codes

How To Series; List of the internal event codes

How To Series; Syntax guidelines for setting events

How To Series; Syntax guidelines for setting events

Unix Series; ora_top.sh, find top os cpu and memory consumers sample shell script

Unix Series; ora_top.sh, find top os cpu and memory consumers sample shell script

10g Series; ASH(Active Session History) Samples

10g Series; ASH(Active Session History) Samples

What is SQL*Plus Arraysize?

What is SQL*Plus Arraysize?

How To Series; Web services with PL/SQL

How To Series; Web services with PL/SQL

How To Series; PL/SQL can participate in a Service Oriented Architecture

What is Oracle Call Interface(OCI)?

What is Oracle Call Interface(OCI)?

How To Series; Find the hidden parameters

How To Series; Find the hidden parameters

10g Series; Wait Event Enhancements

10g Series; Wait Event Enhancements enqueue, latch free

How To Series; Get the size of a column, Vsize function

How To Series; Get the size of a column, Vsize function

How To Series; Restrict access to database for IP adresses or Sql*plus

How To Series; Restrict access to database for IP adresses or Sql*plus

10g Series; Use STATISTICS_LEVEL parametr for MONITORING option

10g Series; Use STATISTICS_LEVEL parametr for MONITORING option

Object orientation in PL/SQL

Object orientation in PL/SQL, part 1

Object orientation in PL/SQL, part 2

object table versus relational table

Bulk operations in PL/SQL, consists three parts

Bulk operations in PL/SQL, consists three parts

Importance of bind variable usage, 10046 Trace Analysis Sample

Importance of bind variable usage, 10046 Trace Analysis Sample

Friday, August 18, 2006

How To Series; UTL_INADDR, find ip and machine name in PL/SQL

How To Series; UTL_INADDR, find ip and machine name in PL/SQL

Table compression tests

Part 1

Part 2

ORACLE ANALYTICAL SQL, A BEGINNER’S GUIDE SERIES

ORACLE ANALYTICAL SQL, A BEGINNER’S GUIDE SERIES; Analytics Overview-RANK AND DENSE_RANK FUNCTIONS-CUBE FUNCTION-ROLLUP FUNCTION

Unix Series; Finding ORACLE_HOME value

Unix Series; Finding ORACLE_HOME value

9i Series; Pipelined Table Function Example

9i Series; Pipelined Table Function Example

9i Series; Record based Update Example

9i Series; Record based Update Example

Default user and passwords, needs attention for security

Default user and passwords, needs attention for security

DBMS_METADATA, a simple metada backup example

DBMS_METADATA, a simple metada backup example

SYS_GUID, generates and returns a globally unique identifier

SYS_GUID, generates and returns a globally unique identifier (RAW value) made up of 16 bytes

Soundex, a function to match the sounds(Phonetic Representation)

Soundex, a function to match the sounds (Returns Character String Constaining The Phonetic Representation Of Another String)

10g Release 2 Series; 9iR2 Number versus 10gR2 Binary_double

>10g Release 2 Series; 9iR2 Number versus 10gR2 Binary_double

10g Release 2 Series; DBMS_UTILITY.FORMAT_ERROR_BACKTRACE

10g Release 2 Series; DBMS_UTILITY.FORMAT_ERROR_BACKTRACE

10g Release 2 Series; DBMS_ERRLOG

10g Release 2 Series; DBMS_ERRLOG

Char data type, comparison sample

Char data type, comparison sample

Blank-Padded and Nonpadded Comparison Semantics

10g Series; drop database, carefull not a joke

10g Series; drop database, carefull not a joke

10g Series; alter system flush buffer_cache, good for testing

10g Series; alter system flush buffer_cache, good for testing

Unix Series; Mknod for fast data transfer, sample sheel script

Unix Series; Mknod for fast data transfer, sample sheel script

Unix Series; 32-bit or 64-bit Oracle?

Unix Series; 32-bit or 64-bit Oracle?

Jdbc Series; Jdbc performance on Oracle

Part 1-AutoCommit Affect Sample

Part 2-Batching Affect Sample

Part 3-Prepared Statement and Binding Affect Sample

Part 4-And the others

History of Oracle

History of Oracle

10g Series; EZCONNECT, Easy Connect String

10g Series; EZCONNECT, Easy Connect String

10g Series; DBMS_FILE_TRANSFER

10g Series; DBMS_FILE_TRANSFER

10g Series; UTL_COMPRESS, zip in database

10g Series; UTL_COMPRESS, zip in database

10g Series; Compile-Time Warnings

10g Series; Compile-Time Warnings

10g Series; PL/SQL Native Compilation, much more easy

10g Series; PL/SQL Native Compilation, much more easy

Transactions and Oracle

Transaction Management at Oracle

Sample Alert.log analysis with external tables and analytic functions

Sample Alert.log analysis with external tables and analytic functions

The Storage Hierarchy in an Oracle Database

The Storage Hierarchy in an Oracle Database

10g Series; Lock holding session identification

10g Series; Lock holding session identification

10g Series; New SQL*Plus features

10g Series; New SQL*Plus features

10g Series; Changes on Autotrace and Dual table

10g Series; Changes on Autotrace and Dual table

10g Series; guess table size, analysing the growth trend of a segment and Online segment shrink

10g Series; guess table size; dbms_space.create_table_cost, analysing the growth trend of a segment; dbms_space.OBJECT_GROWTH_TREND and Online segment shrink; alter table shrink space compact

10g Series; Flashback Table and Recyclebin

10g Series; Flashback Table and Recyclebin

10g Release 2 Series; Renaming a tablespace

10g Release 2 Series; Renaming a tablespace

10g Release 2 Series; Transparent Data Encryption

10g Release 2 Series; Transparent Data Encryption

10g Series; References

10g Series; References

10g Series; views for usage pattern of the database

10g Series; views for usage pattern of the database

10g Series; Flashback Versions Query, “Get a Movie, Not a Picture”

10g Series; Flashback Versions Query, “Get a Movie, Not a Picture”

10g Release 2 Series; dbms_monitor.session_trace_enable

10g Release 2 Series; dbms_monitor.session_trace_enable

10g Release 2 Series; Asynchronous COMMIT

10g Release 2 Series; Asynchronous COMMIT

Another interesting Dba View; V$FLASH_RECOVERY_AREA_USAGE

Another interesting Dba View; V$FLASH_RECOVERY_AREA_USAGE

10g Release 2 Series; Some new RMAN views, V$RMAN_BACKUP_JOB_DETAILS, V$RMAN_BACKUP_TYPE, V$RMAN_OUTPUT

10g Release 2 Series; Unlimited DBMS Output

10g Release 2 Series; Unlimited DBMS Output

10g Release 2 Series; Unlimited DBMS Output

Comments on Oracle certification

Comments on Oracle certification

also the very known Tom Kyte is not an OCP :)

Opening Note; Tonguc.OracleTURK.org

The moral of the story..

Links


Turkish Oracle Users (DBA & Developers)

Do you really want to be an Oracle-Man? FOLLOW Thomas KYTE

Oracle documentation is here

Oracle Discussion Forums

Oracle Technology Network

Examples and Reference Materials for Oracle

About Me

H.Tonguç YILMAZ
tonguc.yilmaz@gmail.com