Oracle-L: RE: Select from Long Datatype Field to INSERT into a Varchar2 Dat atype Field

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 24 Jul 2002 06:53:37 -0800
Message-ID: <F001.004A0D17.20020724065337@fatcity.com>

Srinath,List

Can you give some Detail ?

Thanks to All

-----Original Message-----
Sent: Wednesday, July 24, 2002 12:31 PM
To: LazyDBA.com Discussion
Dat atype Field

You can do this in PL/SQL, not in SQL/Plus

	-----Original Message-----
	From:	Ganesh Raja [SMTP:ganesh_at_gtfs-gulf.com]
	Sent:	24 July, 2002 12:12 PM
	To:	LazyDBA.com Discussion
	Subject:	RE: Select from Long Datatype Field to INSERT into a

Varchar2 Dat atype Field

No That is Not Possible.. Another reason to move to Clob...

HTH

	Best Regards,
	Ganesh R
	Tel  : +971 (4)  397 3337  Ext 420
	Fax  : +971 (4)  397 6262
	HP   : +971 (50) 745 6019
	============================================
	Live to learn... forget... and learn again. 
	============================================



	-----Original Message-----
	From: VIVEK_SHARMA [mailto:VIVEK_SHARMA_at_infosys.com] 
	Sent: Wednesday, July 24, 2002 10:11 AM
	To: LazyDBA.com Discussion
	Subject: Select from Long Datatype Field to INSERT into a Varchar2
Datatype
	Field



	Qs How is Select of Data from a Long Datatype Field to INSERT into a
	Varchar2 Datatype Field 
	in another Table possible ?


	--------
	Oracle documentation is here:
	http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
	To unsubscribe: send a blank email to
oracledba-unsubscribe_at_LAZYDBA.com
	To subscribe:   send a blank email to
oracledba-subscribe_at_LAZYDBA.com
	Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
	Tell yer mates about http://www.farAwayJobs.com
	By using this list you agree to these
	terms:http://www.lazydba.com/legal.html

	--------
	Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
	To unsubscribe: send a blank email to
oracledba-unsubscribe_at_LAZYDBA.com
	To subscribe:   send a blank email to
oracledba-subscribe_at_LAZYDBA.com
	Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
	Tell yer mates about http://www.farAwayJobs.com
	By using this list you agree to these

terms:http://www.lazydba.com/legal.html

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jul 24 2002 - 09:53:37 CDT