Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.91 KB | None | 0 0
  1. SQL> desc customer
  2. Name Null? Type
  3. ----------------------------------------- -------- ----------------------------
  4. ID NUMBER
  5. NAME VARCHAR2(40)
  6.  
  7. SQL> desc orders
  8. Name Null? Type
  9. ----------------------------------------- -------- ----------------------------
  10. ID NUMBER
  11. ORDERID NUMBER
  12.  
  13. SQL> desc orderrad
  14. Name Null? Type
  15. ----------------------------------------- -------- ----------------------------
  16. ORDERID NUMBER
  17. ARTICLEID NUMBER
  18.  
  19. SQL> desc articles
  20. Name Null? Type
  21. ----------------------------------------- -------- ----------------------------
  22. ARTICLEID NUMBER
  23. PRICE NUMBER
  24.  
  25. SQL> select * from customer
  26. 2 ;
  27.  
  28. ID NAME
  29. ---------- ----------------------------------------
  30. 1 bob
  31. 2 mary
  32. 3 frank
  33.  
  34. SQL> select * from orders;
  35.  
  36. ID ORDERID
  37. ---------- ----------
  38. 1 1
  39. 1 2
  40. 2 3
  41. 2 4
  42. 3 5
  43. 3 6
  44. 3 7
  45.  
  46. 7 rows selected.
  47.  
  48. SQL> select * from orderrad;
  49.  
  50. ORDERID ARTICLEID
  51. ---------- ----------
  52. 1 1
  53. 1 1
  54. 1 1
  55. 2 2
  56. 2 3
  57. 3 4
  58. 3 1
  59. 3 3
  60. 4 1
  61. 4 2
  62. 4 2
  63.  
  64. ORDERID ARTICLEID
  65. ---------- ----------
  66. 4 2
  67. 4 2
  68. 4 2
  69. 4 2
  70. 5 1
  71. 5 3
  72. 5 3
  73. 5 3
  74. 6 2
  75. 6 2
  76. 6 2
  77.  
  78. ORDERID ARTICLEID
  79. ---------- ----------
  80. 6 2
  81. 6 2
  82. 6 2
  83. 6 2
  84. 6 2
  85. 6 2
  86. 6 2
  87. 7 3
  88. 7 3
  89. 7 3
  90. 7 3
  91.  
  92. ORDERID ARTICLEID
  93. ---------- ----------
  94. 7 3
  95. 7 3
  96. 7 3
  97. 8 1
  98. 8 1
  99. 8 1
  100. 8 1
  101. 8 1
  102. 8 1
  103. 8 1
  104. 8 1
  105.  
  106. ORDERID ARTICLEID
  107. ---------- ----------
  108. 8 1
  109. 8 1
  110. 8 1
  111.  
  112. 47 rows selected.
  113.  
  114. SQL> select * from articles;
  115.  
  116. ARTICLEID PRICE
  117. ---------- ----------
  118. 1 99.99
  119. 2 1
  120. 3 55.55
  121. 4 99.44
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement