SQL Plus

From TekiWiki

Jump to: navigation, search

This whole wiki has now moved to http://www.springboardsolutions.com/wiki

Go to this page SQL Plus

Line 69: Line 69:
column colFileSuffix new_value FileSuffix
column colFileSuffix new_value FileSuffix
-
select name || '_' || to_char(sysdate,'YYYYMMDD_HH24MISS') colFileSuffix
+
select  
 +
name||'_'||to_char(sysdate,'YYYY-MM-DD-HH24-MI-SS') colFileSuffix
from v$database;
from v$database;

Revision as of 16:02, 11 December 2011

Personal tools