[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:	DEC Rdb against the World

Moderator:	HERON::GODFRIND

Created:	Fri Jun 12 1987
Last Modified:	Thu Feb 23 1995
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1348
Total number of notes:	5438

1196.0. "only 1 VARCHAR per table in ORACLE" by CSC32::S_MAUFE (out of town guests need to drive) Thu Oct 08 1992 21:15

    couldn't find agood place for this,
    
    but ORACLE only allows 1 column in table to be VARCHAR! I just spoke to a
    customer who performed some magic to concatenate evyerthing into this
    one variable length string, using NULLs to seperate data.
    
    Simon

T.R	Title	User	Personal Name	Date	Lines
1196.1		NOVA::NOVA::R_ANDERSON	My timing is Digital.	`Thu Oct 08 1992 21:27`	5
	What version of Oracle are you talking about? My ORACLE v6.0 manual specifically indicates that CHAR and VARCHAR are equivalent, and any number may be specified per table (it also mentions that this MAY NOT be true in future releases). Rick
1196.2		CSC32::S_MAUFE	out of town guests need to drive	`Thu Oct 08 1992 21:48`	4
	dunno - should have asked, sorry! Simon