Posted By

bbrumm on 02/18/17


Tagged

sql Oracle


Versions (?)

Oracle DUMP Function


 / Published in: SQL
 

URL: http://www.databasestar.com/oracle-dump/

A few examples of the DUMP function.

  1. SELECT DUMP('Database Star') AS DUMP_TEST FROM dual;
  2.  
  3. SELECT DUMP('Database Star', 8) AS DUMP_TEST FROM dual;
  4.  
  5. SELECT DUMP('Database Star', 10) AS DUMP_TEST FROM dual;
  6.  
  7. SELECT DUMP('Database Star', 16) AS DUMP_TEST FROM dual;
  8.  
  9. SELECT DUMP('Database Star', 17) AS DUMP_TEST FROM dual;
  10.  
  11. SELECT DUMP('Database Star', 1008) AS DUMP_TEST FROM dual;
  12.  
  13. SELECT DUMP('Database Star', 10, 9) AS DUMP_TEST FROM dual;
  14.  
  15. SELECT DUMP('Database Star', 10, 9, 5) AS DUMP_TEST FROM dual;
  16.  
  17. SELECT first_name, DUMP(first_name) AS DUMP_TEST FROM student;

Report this snippet  

You need to login to post a comment.