Search notes:

Oracle: Order of invisible columns

create table tq84_invis_col (
    col_a      number,
    col_b      number      invisible,
    col_c      number
);

insert into tq84_invis_col (col_a, col_b, col_c) values (1, 2, 3);
Data dictionary:
select
   col.column_id,
   col.column_name,
   col.data_type
from
   user_tab_columns col
where
   col.table_name = 'TQ84_INVIS_COL'
order by
   col.column_name;
--
-- COLUMN_ID  COLUMN_NAME  DATA_TYPE 
-- ---------  -----------  ---------
--         1  COL_A        NUMBER    
--            COL_B        NUMBER    
--         2  COL_C        NUMBER    
alter table    tq84_invis_col modify col_b visible;

select * from tq84_invis_col;
-- 
--      COL_A      COL_C      COL_B
-- ---------- ---------- ----------
--          1          3          2
Cleaning up
drop table tq84_invis_col;

See also

Invisible columns

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758206881, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/objects/tables/columns/invisible/order(73): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78