Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: invisible
How can I see my invisible columns
A cool new feature in 12c is the ability to make a column invisible. The concept has existed since 8i to handle things like “set unused” and function based indexes, but now it is available to developers directly. SQL> create table T ( c1…
12c invisible columns
As several bloggers have already pointed out, column order changes when you start playing with invisible columns, for example SQL> create table T ( c1 int, c2 int, c3 int ); Table created. SQL> desc T Name Null? Type —————————————– ——– ————— C1 NUMBER(38)…
