Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie question
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