Snippet Name: Date Functions: DUMP
Description: DUMP returns a VARCHAR2 value containing the datatype code, length in bytes, and the internal representation of a value.
start_position and length are optional parameters. They determines which portion of the internal representation to display. If these parameters are omitted, the dump function will display the entire internal representation in decimal notation.
Also see:
» FUNCTIONS: date/time
» UPDATE: Update a partitioned table
» UPDATE: Update based on a record
» UPDATE: Update Object Table
» UPDATE: with RETURNING clause
» UPDATE: Nested Table Update example
» UPDATE: Correlated Update
» UPDATE: Update from a SELECT statement
» UPDATE: based on multiple returned val...
» UPDATE: Update based on a query
» UPDATE: Update multiple rows
» UPDATE: update a specific record
» UPDATE: Single row
» Date Functions: EXTRACT
» Date Functions: TO_DSINTERVAL
» Date Functions: TO_NCHAR
» Date Functions: TO_YMINTERVAL
» Date Functions: Calculate elapsed time...
» Date and Time Calculations: Get second...
» Date: Find first day of the month
» Date Calculations
» Date Functions: WHERE Clause Joins
» Date Functions: TRUNC
» Date Functions: SYSDATE
» Date Functions: TO_CHAR
» Date Functions: ROUND
» Date Functions: NEXT_DAY
» Date Functions: NEW_TIME
» Date Functions: MONTHS_BETWEEN
» Date Functions: MIN
Comment: (none)
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 03rd, 2009
|
DUMP(<expression> [,<return_format>[,<start_position>[,<length>]]])
-- expression is the expression to analyze.
-- return_format is optional. It determines the format of
-- the return value. This parameter can be any of the following
-- values:
------------------------------------------------------
VALUE Explanation
------------------------------------------------------
8 octal notation
10 DECIMAL notation
16 hexadecimal notation
17 single characters
1008 octal notation WITH the character SET name
1010 DECIMAL notation WITH the character SET name
1016 hexadecimal notation WITH the character SET name
1017 single characters WITH the character SET name
------------------------------------------------------
col drows format a40
SELECT DUMP(SYSDATE) DROWS FROM dual;
SELECT DUMP(SYSDATE, 8) DROWS FROM dual;
SELECT DUMP(SYSDATE, 16) DROWS FROM dual;
|
