Board index » off-topic » CHAR OR VARCHAR (Oracle and BDE)
JM Granier
Delphi Developer |
JM Granier
Delphi Developer |
CHAR OR VARCHAR (Oracle and BDE)2003-12-01 06:06:23 PM off-topic18 Hello, I'm (still) using BDE on SQL server or ORACLE Databases. I need to apply filter on db string fields with trim function depending on the field is CHAR or VARCHAR type. I would like to know How can we retrieve the datatype information of a db stringfield : is the field is char or varchar ? Thank you JM |
Mike Shkolnik
Delphi Developer |
2003-12-01 09:03:01 PM
Re:CHAR OR VARCHAR (Oracle and BDE)
You may retrieve a list of fields from ALL_TAB_COLUMNS. This is a system
view in Oracle: SELECT * FROM ALL_TAB_COLUMNS WHERE (TABLE_NAME = 'yourTableName') AND (OWNER = 'yourScheme'); Original field type is there too "JM Granier" < XXXX@XXXXX.COM >сообщи?сообщила ?новостях следующе? news: XXXX@XXXXX.COM ... QuoteHello, |
JM Granier
Delphi Developer |
2003-12-01 11:04:41 PM
Re:CHAR OR VARCHAR (Oracle and BDE)
Ouhaouh
super gИnial (in french) Greeeaaattt!! many thanks. JM "Mike Shkolnik" < XXXX@XXXXX.COM >a Иcrit dans le message de QuoteYou may retrieve a list of fields from ALL_TAB_COLUMNS. This is a system {smallsort} |
JM Granier
Delphi Developer |
2003-12-01 11:23:24 PM
Re:CHAR OR VARCHAR (Oracle and BDE)
in Sql Server :
select syscolumns.name as champ, systypes.name as fieldtype, syscolumns.usertype from syscolumns, systypes, sysobjects where sysobjects.name='yourtable' and sysobjects.id=syscolumns.id and systypes.usertype=syscolumns.usertype order by syscolumns.name |