Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL> desc customer
- Name Null? Type
- ----------------------------------------- -------- ----------------------------
- ID NUMBER
- NAME VARCHAR2(40)
- SQL> desc orders
- Name Null? Type
- ----------------------------------------- -------- ----------------------------
- ID NUMBER
- ORDERID NUMBER
- SQL> desc orderrad
- Name Null? Type
- ----------------------------------------- -------- ----------------------------
- ORDERID NUMBER
- ARTICLEID NUMBER
- SQL> desc articles
- Name Null? Type
- ----------------------------------------- -------- ----------------------------
- ARTICLEID NUMBER
- PRICE NUMBER
- SQL> select * from customer
- 2 ;
- ID NAME
- ---------- ----------------------------------------
- 1 bob
- 2 mary
- 3 frank
- SQL> select * from orders;
- ID ORDERID
- ---------- ----------
- 1 1
- 1 2
- 2 3
- 2 4
- 3 5
- 3 6
- 3 7
- 7 rows selected.
- SQL> select * from orderrad;
- ORDERID ARTICLEID
- ---------- ----------
- 1 1
- 1 1
- 1 1
- 2 2
- 2 3
- 3 4
- 3 1
- 3 3
- 4 1
- 4 2
- 4 2
- ORDERID ARTICLEID
- ---------- ----------
- 4 2
- 4 2
- 4 2
- 4 2
- 5 1
- 5 3
- 5 3
- 5 3
- 6 2
- 6 2
- 6 2
- ORDERID ARTICLEID
- ---------- ----------
- 6 2
- 6 2
- 6 2
- 6 2
- 6 2
- 6 2
- 6 2
- 7 3
- 7 3
- 7 3
- 7 3
- ORDERID ARTICLEID
- ---------- ----------
- 7 3
- 7 3
- 7 3
- 8 1
- 8 1
- 8 1
- 8 1
- 8 1
- 8 1
- 8 1
- 8 1
- ORDERID ARTICLEID
- ---------- ----------
- 8 1
- 8 1
- 8 1
- 47 rows selected.
- SQL> select * from articles;
- ARTICLEID PRICE
- ---------- ----------
- 1 99.99
- 2 1
- 3 55.55
- 4 99.44
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement