SQL*Plus Question

  • From: Dennis Williams <oracledba.williams@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 9 Feb 2009 13:16:11 -0600

List,

So, I'm trying to generate a list of CREATE TABLESPACE statements from
DBA_DATA_FILES. I'm having trouble putting single quotes around the datafile
name. This is frustrating because I seem to have forgotten how to do this. I
thought there is a SQL function that would let you enter the hexadecimal
value of a character you want printed.

This is 10.2.0.4 on Solaris, but I don't think that matters.

Thanks,
Dennis Williams

Other related posts: