1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
|
Connected to Oracle Database 10g Express Edition Release 10.2.0.1.0
Connected as mni
SQL>
SQL> create table t_mere (
2 id_mere int primary key,
3 lib varchar2(10)
4 )
5 /
Table created
SQL> create table t_fils (
2 id int primary key,
3 id_mere references t_mere,
4 text varchar2(20)
5 )
6 /
Table created
SQL> insert all
2 into t_mere
3 values (1, 'mere 1')
4 into t_mere
5 values (2, 'mere 2')
6 into t_mere
7 values (3, 'mere 3')
8 Select Null
9 From dual
10 /
3 rows inserted
SQL> insert all
2 into t_fils
3 values (100, 1, 'fils 100 mere 1')
4 into t_fils
5 values (101, 1, 'fils 101 mere 1')
6 into t_fils
7 values (200, 2, 'fils 200 mere 2')
8 into t_fils
9 values (201, 2, 'fils 201 mere 2')
10 Select Null
11 From dual
12 /
4 rows inserted
SQL> commit
2 /
Commit complete
SQL> |
Partager