Posted By

bbrumm on 02/18/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 02/18/17 09:11am

Statistics

Viewed 733 times

Favorited by 0 user(s)

Related snippets

Oracle DUMP Function

/ Published in: SQL

A few examples of the DUMP function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT DUMP('Database Star') AS DUMP_TEST FROM dual;
 
SELECT DUMP('Database Star', 8) AS DUMP_TEST FROM dual;
 
SELECT DUMP('Database Star', 10) AS DUMP_TEST FROM dual;
 
SELECT DUMP('Database Star', 16) AS DUMP_TEST FROM dual;
 
SELECT DUMP('Database Star', 17) AS DUMP_TEST FROM dual;
 
SELECT DUMP('Database Star', 1008) AS DUMP_TEST FROM dual;
 
SELECT DUMP('Database Star', 10, 9) AS DUMP_TEST FROM dual;
 
SELECT DUMP('Database Star', 10, 9, 5) AS DUMP_TEST FROM dual;
 
SELECT first_name, DUMP(first_name) AS DUMP_TEST FROM student;