Re: Copying the structure

pankaj_wolfhunter_at_yahoo.co.in wrote:
> thanks Michael. I got what I wanted.
> For my knowledge, is 'DDD' something which has to be given?
>

Michael's solution converts the timestamp to a number. In his solution, he uses the 'DDD' format mask to convert the date to the day of the year. The format masks are documented here:

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm#i34510

You didn't specify your Oracle version, but if you are using Oracle 9i or higher, any reason you couldn't use DBMS_METADATA to generate the DDL to create your table? I know you wanted this all in one SELECT statement, so I'm just curious.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown