1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
CREATE TABLE MATABLE (VILLE VARCHAR2(15), EXERCICE DOUBLE PRECISION, MOIS DOUBLE PRECISION, CA DOUBLE PRECISION)
Table created
select data_type, data_length, data_precision, column_name from user_tab_columns where table_name='MATABLE'
DATA_TYPE DATA_LENGTH DATA_PRECISION COLUMN_NAME
--------- ----------- -------------- ------------------------------
VARCHAR2 15 VILLE
FLOAT 22 126 EXERCICE
FLOAT 22 126 MOIS
FLOAT 22 126 CA
4 rows selected
insert into matable values (1,1/3,1/7,1/13)
1 row inserted
select sum(exercice)/sum(mois) from matable
SUM(EXERCICE)/SUM(MOIS)
-----------------------
2.33333333333333
1 row selected |
Partager