DEC TO HEX CONVERSION WHILE IMPORTING
From: MUSTAFA (mustafakh_at_yahoo.com)
Date: 05/12/04
- Next message: Nikhil: "Re: getting sum of units sold in preceeding weeks"
- Previous message: MUSTAFA: "Re: Third largest salary"
- Next in thread: Steve Kass: "Re: DEC TO HEX CONVERSION WHILE IMPORTING"
- Reply: Steve Kass: "Re: DEC TO HEX CONVERSION WHILE IMPORTING"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 12 May 2004 00:03:16 -0700
I HAVE DECIMAL NUMBER IN MY TEST TABLE COLUMN CARD_NUMBER
AS FOLLOWS
2571549730.0
2571549826.0
2571550034.0
2571550210.0
2571550306.0
2571551378.0
2571551586.0
2571551682.0
2571551762.0
2571551874.0
I WANT TO CREATE A TEMP TABLE AND MOVE THIS COLUMN BUT
BEFORE MOVING IT SHOULD CONVERT INTO HEXADECIMAL NUMBER
WHILE INSERTING INTO TEMP TABLE
THANKS
- Next message: Nikhil: "Re: getting sum of units sold in preceeding weeks"
- Previous message: MUSTAFA: "Re: Third largest salary"
- Next in thread: Steve Kass: "Re: DEC TO HEX CONVERSION WHILE IMPORTING"
- Reply: Steve Kass: "Re: DEC TO HEX CONVERSION WHILE IMPORTING"
- Messages sorted by: [ date ] [ thread ]