SQL Plus
From TekiWiki
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,' | + | select |
| + | name||'_'||to_char(sysdate,'YYYY-MM-DD-HH24-MI-SS') colFileSuffix | ||
from v$database; | from v$database; | ||