It's actually:
SQL> select To_Date('03/09/2001','MM-DD-'), 2 To_Date('03/09/2001','MM/DD/'), 3 To_Date('03/09/2001 11:11:11','MM/DD/ HH:MI:SS') 4 from dual;
TO_DATE(' TO_DATE(' TO_DATE('- - -09-MAR-01 09-MAR-01 09-MAR-01
SQL> ALTER SESSION SET NLS_DATE_FO
Hello, ALL:
When I insert the query results into a huge temp table (where store all my different query results), How can I track them? so I can spool them out separately to different DATA files?
Use Sequence? RowID? Add another PK? Could you please show me how to use them?
Thanks a lot for help
We
Hello:
I'm trying to spool out couple of files from my temp table. Part of the file name is coming from a variable from the temp table. I use:
spool C:\CYCLE_COUNT_$temp_variable.DAT
but it's only one physical name instead of using the variable.
How can I code the variable name as part of (spool)
e> echo "this_is_a_${temp_variable}_only"this_is_a_TEST_only/home/oracle>
Hope it helps
- Original Message -
From: Helen Zhung
To: Multiple recipients of list ORACLE-L
Sent: Monday, April 23, 2001 2:50 PM
Subject: help - spool file name - use variable
Hello:
I'm t
I tried, but didnot work.
I hard code them now.
Thanks
"Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
How about "spool &report_id.dat" ?-Original Message-Sent: Monday, April 23, 2001 6:22 PMTo: Multiple recipients of list ORACLE-LI'm writing a sql script file (first run couple of queries, i
Hello:
I'm new to SQL Loader. Is there a way to code in control file that can separate 'a tab' and 'a blank space' ?
I use "FIELDS TERMINATED BY WHITESPACE", but it will TERMINATE a field when there is a space or a tab. However, the data fields were separated only by the "tab", not 'a space'. Is it