Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie question

Re: Newbie question

From: <lothar.behrens_at_lollisoft.de>
Date: 6 Feb 2006 15:21:02 -0800
Message-ID: <1139268062.485753.273390@f14g2000cwb.googlegroups.com>


Hi,

with some tries on htmldb, I got two working tables with the needed sequences.
Now I know, that triggers are used to populate the primary keys.

For the BOOL type, I also didn't find a BIT type. That would be my fall back on
ODBC level to detect the type to be a check box on the GUI side.

The column_types table didn't really explain me the datatypes. I'll get that with
SQLDescribeCol or the like.

But it would help me to define a column to be readonly in the GUI, because it would
be populated with serials or sequences like customer numbers that shouldn't be
changed after creation - in my understanding.

So for me, this table has a place to be - currently.

Ah, the 'on the fly' part for me is the GUI, not the queries or the tables.

For now, I have little more understanding about Oracle - not much, but a starting point.

Thanks, Lothar Received on Mon Feb 06 2006 - 17:21:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US