Archives: 05/16/2014

Decimal, float, double

DECIMAL – diviso per zero dà errore – permette la rappresentazione esatta di un numero decimale – è in base 10 – decimal: precisione 28 cifre – campo finanziario DOUBLE / FLOAT – diviso per zero non dà errore – non permette la rappresentazione esatta di un numero decimale (0,1 sarà 0,10000000000000001) – sistema binario…

Oracle schema

QUERYING CONSTRAINTS SELECT co.table_name, co.column_name, co.position, c.constraint_name, c.constraint_type, c.index_name, c.status, c.last_change FROM user_constraints c INNER JOIN user_cons_columns co ON c.constraint_name = co.constraint_name AND c.owner = co.owner WHERE c.constraint_type = ‘P’ AND co.table_name= ‘ANAG_AREE’ ORDER BY co.table_name, co.position; [It’s possible to use <all_constraints, all_cons_columns> replacing <user_constraints, user_cons_columns> to view all onwners] C – Check constraint on…

Go Top