 | |
NULL values in IN condition
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: NULL values in IN condition -
12-12-2008
, 05:38 AM
|
Álvaro G. Vicario, 12.12.2008 11:34: Carlos escribió: Why on earth could someone define a column as varchar2(1)?? What's your suggestion to store a single character? Mine would be: CHAR(1) |
Cheers.
Carlos.
#22
| |||
| |||
|
|
Álvaro G. Vicario, 12.12.2008 11:34: Carlos escribió: Why on earth could someone define a column as varchar2(1)?? What's your suggestion to store a single character? Mine would be: CHAR(1) |
I had assumed that, since it didn't have the leading "2" as in VARCHAR2
it was one of those peculiar Oracle types tagged as "do not use!" like,
well, VARCHAR. And something that didn't help is that SQL Developer
doesn't allow such type in the "Add column" dialog.
This is what happens when you code in more DBMS than you're able to learn xD
--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
--
#23
| |||
| |||
|
|
Álvaro G. Vicario, 12.12.2008 11:34: Carlos escribió: Why on earth could someone define a column as varchar2(1)?? What's your suggestion to store a single character? Mine would be: CHAR(1) |
I had assumed that, since it didn't have the leading "2" as in VARCHAR2
it was one of those peculiar Oracle types tagged as "do not use!" like,
well, VARCHAR. And something that didn't help is that SQL Developer
doesn't allow such type in the "Add column" dialog.
This is what happens when you code in more DBMS than you're able to learn xD
--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
--
#24
| |||
| |||
|
|
Álvaro G. Vicario, 12.12.2008 11:34: Carlos escribió: Why on earth could someone define a column as varchar2(1)?? What's your suggestion to store a single character? Mine would be: CHAR(1) |
I had assumed that, since it didn't have the leading "2" as in VARCHAR2
it was one of those peculiar Oracle types tagged as "do not use!" like,
well, VARCHAR. And something that didn't help is that SQL Developer
doesn't allow such type in the "Add column" dialog.
This is what happens when you code in more DBMS than you're able to learn xD
--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
--
#25
| |||
| |||
|
|
Álvaro G. Vicario, 12.12.2008 11:34: Carlos escribió: Why on earth could someone define a column as varchar2(1)?? What's your suggestion to store a single character? Mine would be: CHAR(1) |
I had assumed that, since it didn't have the leading "2" as in VARCHAR2
it was one of those peculiar Oracle types tagged as "do not use!" like,
well, VARCHAR. And something that didn't help is that SQL Developer
doesn't allow such type in the "Add column" dialog.
This is what happens when you code in more DBMS than you're able to learn xD
--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
--
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.