fork download
copy 
  1.  
  2. drop table Customer;
  3. drop table Account; 
  4. drop table Branch;
  5. drop table Employee;
  6. DROP table SALGRADE;
  7. drop table Loan;
  8. drop table Return;
  9. drop table Loan_return;
  10. drop table InfoTran;
  11. drop table Transaction;
  12. drop table Borrower;
  13. drop table Depositor;
  14. drop table Cust_banker;
  15. drop table Loan_Branch;
  16.  
  17.  
  18.  
  19.  
  20.  
  21.  
  22.  
  23. Create table Customer
  24. (
  25. 	Cust_id 	VARCHAR2(12)  NOT NULL,
  26. 	Cust_name	VARCHAR2(12),
  27. 	Cust_dob	DATE,
  28. 	Cust_street	VARCHAR2(12),
  29. 	Cust_city	VARCHAR2(12)
  30. );
  31.  
  32. Create table Account
  33. (
  34. 	Account_id 	VARCHAR2(12)  NOT NULL,
  35. 	Balance		NUMBER(20,5),
  36. 	Type		VARCHAR2(8)
  37. );
  38.  
  39. Create table Branch
  40. (
  41. 	Branch_name	VARCHAR2(14)  NOT NULL,
  42. 	Branch_city	VARCHAR2(10),
  43. 	Assets		NUMBER(20,5)
  44. );
  45.  
  46. Create table Employee
  47. (
  48. 	Employee_id	VARCHAR2(12),
  49. 	Employee_name	VARCHAR2(20),
  50. 	Employee_dob	DATE,
  51. 	Employee_street	VARCHAR2(20),
  52. 	Employee_city	VARCHAR2(20),
  53. 	Employee_startdate DATE,
  54. 	Salary		NUMBER(10,3),
  55. 	MGR		VARCHAR2(12)
  56. );
  57.  
  58. Create table SALGRADE
  59. (
  60. 	GRADE	VARCHAR2(5)  NOT NULL,
  61. 	LOSAL	NUMBER(10,3),
  62. 	HISAL	NUMBER(10,3)	
  63. );
  64.  
  65. Create table Loan
  66. (
  67. 	Loan_id 	VARCHAR2(12)  NOT NULL,
  68. 	Amount		NUMBER(20,5)				
  69. );
  70. Create table Return
  71. (
  72. 	Payment_id 	VARCHAR2(12)  NOT NULL,
  73. 	Loan_id 	VARCHAR2(12)  NOT NULL
  74. );
  75.  
  76. Create table Loan_return
  77. (
  78. 	Payment_id 	VARCHAR2(12)  NOT NULL,
  79. 	Payment_amount	NUMBER(20,5),				
  80. 	Payment_date	Date
  81. );
  82.  
  83. Create table InfoTran
  84. (
  85. 	Transaction_id	 VARCHAR2(20) NOT NULL,
  86. 	Transaction_date DATE,
  87. 	Type		 VARCHAR2(8),
  88. 	Amount		 NUMBER(20,5)
  89. );
  90.  
  91. Create table Transaction
  92. (
  93. 	Transaction_id	 VARCHAR2(20) NOT NULL,
  94. 	Account_id	 VARCHAR2(12) NOT NULL
  95. );
  96. Create table Borrower
  97. (
  98. 	Cust_id 	VARCHAR2(12)  NOT NULL,
  99. 	Loan_id 	VARCHAR2(12)  NOT NULL
  100. );
  101. Create table Depositor
  102. (
  103. 	Cust_id 	VARCHAR2(12)  NOT NULL,
  104. 	Account_id	 VARCHAR2(12) NOT NULL
  105. );
  106.  
  107. Create table Cust_banker
  108. (
  109. 	Customer_id 	VARCHAR2(12)  NOT NULL,
  110. 	Employee_id	VARCHAR2(12)  NOT NULL		
  111. );
  112. Create table Loan_Branch
  113. (
  114. 	Loan_id 	VARCHAR2(12)  NOT NULL,
  115. 	Branch_name	VARCHAR2(14)  NOT NULL
  116. );
  117.  
  118.  
  119.  
  120.  
  121.  
  122. insert into account values('A-101',500, 'CURRENT');
  123. insert into account values('A-215',700, 'CURRENT');
  124. insert into account values('A-102',400, 'CURRENT');
  125. insert into account values('A-305',350, 'CURRENT');
  126. insert into account values('A-201',900, 'CURRENT');
  127. insert into account values('A-222',700, 'CURRENT');
  128. insert into account values('A-217',750, 'CURRENT');
  129.  
  130. insert into borrower values('C00000000001','L-17');
  131. insert into borrower values('C00000000002','L-23');
  132. insert into borrower values('C00000000003','L-15');
  133. insert into borrower values('C00000000009','L-14');
  134. insert into borrower values('C00000000004','L-93');
  135. insert into borrower values('C00000000002','L-11');
  136. insert into borrower values('C00000000007','L-17');
  137. insert into borrower values('C00000000008','L-16');
  138.  
  139. insert into branch values('Downtown','Brooklyn',9000000);
  140. insert into branch values('Redwood','Palo Alto',21000000);
  141. insert into branch values('Perryridge','Horseneck',17000000);
  142. insert into branch values('Mianus','Horseneck',400000);
  143. insert into branch values('Round hill','Horseneck',8000000);
  144. insert into branch values('Pownal','Horseneck',300000);
  145. insert into branch values('North town','Rye',3700000);
  146. insert into branch values('Brighton','Brooklyn',710000);
  147.  
  148. insert into customer values('C00000000001','Jones',TO_DATE('11-JAN-1982','DD-MON-YYYY'),'Main','Harrison');
  149. insert into customer values('C00000000002','Smith',TO_DATE('22-JAN-1958','DD-MON-YYYY'),'North','Rye');
  150. insert into customer values('C00000000003','Hayes',TO_DATE('23-FEB-1962','DD-MON-YYYY'),'Main','Harrison');
  151. insert into customer values('C00000000004','Curry',TO_DATE('24-FEB-1964','DD-MON-YYYY'),'North','Rye');
  152. insert into customer values('C00000000005','Lindsay',TO_DATE('25-OCT-1956','DD-MON-YYYY'),'Park','Pittsfield');
  153. insert into customer values('C00000000006','Turner',TO_DATE('26-NOV-1982','DD-MON-YYYY'),'Putnam','Stamford');
  154. insert into customer values('C00000000007','Williams',TO_DATE('27-DEC-1975','DD-MON-YYYY'),'Nassau','Princeton');
  155. insert into customer values('C00000000008','Adams',TO_DATE('28-MAR-1978','DD-MON-YYYY'),'Spring','Pittsfield');
  156. insert into customer values('C00000000009','Johnson',TO_DATE('27-MAR-1974','DD-MON-YYYY'),'Alma','Palo alto');
  157. insert into customer values('C00000000010','Glenn',TO_DATE('21-APR-1956','DD-MON-YYYY'),'Sand Hill','Woodside');
  158. insert into customer values('C00000000011','Brooks',TO_DATE('21-APR-1974','DD-MON-YYYY'),'Senator','Brooklyn');
  159. insert into customer values('C00000000012','Green',TO_DATE('19-APR-1979','DD-MON-YYYY'),'Walnut','Stamford');
  160.  
  161. insert into depositor values('C00000000001','A-101');
  162. insert into depositor values('C00000000002','A-215');
  163. insert into depositor values('C00000000003','A-102');
  164. insert into depositor values('C00000000004','A-305');
  165. insert into depositor values('C00000000001','A-201');
  166. insert into depositor values('C00000000005','A-217');
  167. insert into depositor values('C00000000006','A-222');
  168.  
  169. Insert into Employee values('E00000000001','E_A',TO_DATE('11-JAN-1982','DD-MON-YYYY'),'e_street_006', 'Rajshahi','11-JAN-0002',5000,'');
  170. Insert into Employee values('E00000000002','E_B',TO_DATE('22-JAN-1958','DD-MON-YYYY'),'e_street_005', 'Dhaka','22-JAN-1978',2850,'E00000000001');
  171. Insert into Employee values('E00000000003','E_C',TO_DATE('23-FEB-1962','DD-MON-YYYY'),'e_street_007', 'Mymensingh','23-FEB-1982',2000,'E00000000001');
  172. Insert into Employee values('E00000000004','E_D',TO_DATE('24-FEB-1964','DD-MON-YYYY'),'e_street_004', 'Rangpur','24-FEB-1984',5300,'E00000000001');
  173. Insert into Employee values('E00000000005','E_E',TO_DATE('25-OCT-1956','DD-MON-YYYY'),'e_street_004', 'Barishal','25-OCT-1976',6500,'E00000000001');
  174. Insert into Employee values('E00000000006','E_F',TO_DATE('26-NOV-1982','DD-MON-YYYY'),'e_street_003', 'Dhaka','26-NOV-0002',1700,'E00000000007');
  175. Insert into Employee values('E00000000007','E_G',TO_DATE('27-DEC-1975','DD-MON-YYYY'),'e_street_002', 'Dhaka','27-DEC-1995',9000,'');
  176. Insert into Employee values('E00000000008','E_H',TO_DATE('28-MAR-1978','DD-MON-YYYY'),'e_street_002', 'eRajshahi','28-MAR-1998',5000,'E00000000007');
  177. Insert into Employee values('E00000000009','E_I',TO_DATE('27-MAR-1974','DD-MON-YYYY'),'e_street_001', 'Dhaka','27-MAR-1994',4000,'E00000000007');
  178. Insert into Employee values('E00000000010','E_J',TO_DATE('21-APR-1956','DD-MON-YYYY'),'e_street_018', 'Rajshahi','21-APR-1986',5600,'E00000000007');
  179. Insert into Employee values('E00000000011','E_K',TO_DATE('21-APR-1974','DD-MON-YYYY'),'e_street_017', 'Rangpur','21-APR-1994',1400,'E00000000007');
  180. Insert into Employee values('E00000000012','E_L',TO_DATE('19-APR-1979','DD-MON-YYYY'),'e_street_016', 'Dhaka','19-APR-1999',5600,'E00000000008');
  181. Insert into Employee values('E00000000013','E_M',TO_DATE('29-APR-1974','DD-MON-YYYY'),'e_street_015', 'Rangpur','29-APR-1994',9900,'E00000000008');
  182. Insert into Employee values('E00000000014','E_N',TO_DATE('18-MAY-1976','DD-MON-YYYY'),'e_street_014', 'Barishal','18-MAY-1996',1000,'');
  183. Insert into Employee values('E00000000015','E_O',TO_DATE('17-MAY-1973','DD-MON-YYYY'),'e_street_013', 'Rajshahi','17-MAY-1993',5000,'E00000000014');
  184. Insert into Employee values('E00000000016','E_P',TO_DATE('14-MAY-1982','DD-MON-YYYY'),'e_street_012', 'Barishal','14-MAY-0002',2200,'E00000000014');
  185. Insert into Employee values('E00000000017','E_Q',TO_DATE('11-MAY-1980','DD-MON-YYYY'),'e_street_011', 'Rangpur','11-MAY-2000',3500,'E00000000014');
  186. Insert into Employee values('E00000000018','E_R',TO_DATE('23-JUN-1982','DD-MON-YYYY'),'e_street_010', 'Mymensingh','23-JUN-0002',1500,'E00000000014');
  187. Insert into Employee values('E00000000019','E_S',TO_DATE('26-JUN-1981','DD-MON-YYYY'),'e_street_009', 'Mymensingh','26-JUN-0001',4000,'E00000000014');
  188. Insert into Employee values('E00000000020','E_T',TO_DATE('22-JUN-1981','DD-MON-YYYY'),'e_street_008', 'Barishal','22-JUN-0001',7900,'E00000000014');
  189.  
  190. insert into loan values('L-17',1000);
  191. insert into loan values('L-23',2000);
  192. insert into loan values('L-15',1500);
  193. insert into loan values('L-14',1500);
  194. insert into loan values('L-93',500);
  195. insert into loan values('L-11',900);
  196. insert into loan values('L-16',1300);
  197.  
  198. Insert into SALGRADE values('A',700,1200);
  199. Insert into SALGRADE values('B',1201,1400);
  200. Insert into SALGRADE values('C',1401,2000);
  201. Insert into SALGRADE values('D',2001,3000);
  202. Insert into SALGRADE values('E',3001,9999);
  203. Insert into SALGRADE values('F',9999,99999);
  204.  
Success #stdin #stdout #stderr 0.01s 5320KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 2: no such table: Customer
Error: near line 3: no such table: Account
Error: near line 4: no such table: Branch
Error: near line 5: no such table: Employee
Error: near line 6: no such table: SALGRADE
Error: near line 7: no such table: Loan
Error: near line 8: no such table: Return
Error: near line 9: no such table: Loan_return
Error: near line 10: no such table: InfoTran
Error: near line 11: near "Transaction": syntax error
Error: near line 12: no such table: Borrower
Error: near line 13: no such table: Depositor
Error: near line 14: no such table: Cust_banker
Error: near line 15: no such table: Loan_Branch
Error: near line 91: near "Transaction": syntax error
Error: near line 148: no such function: TO_DATE
Error: near line 149: no such function: TO_DATE
Error: near line 150: no such function: TO_DATE
Error: near line 151: no such function: TO_DATE
Error: near line 152: no such function: TO_DATE
Error: near line 153: no such function: TO_DATE
Error: near line 154: no such function: TO_DATE
Error: near line 155: no such function: TO_DATE
Error: near line 156: no such function: TO_DATE
Error: near line 157: no such function: TO_DATE
Error: near line 158: no such function: TO_DATE
Error: near line 159: no such function: TO_DATE
Error: near line 169: no such function: TO_DATE
Error: near line 170: no such function: TO_DATE
Error: near line 171: no such function: TO_DATE
Error: near line 172: no such function: TO_DATE
Error: near line 173: no such function: TO_DATE
Error: near line 174: no such function: TO_DATE
Error: near line 175: no such function: TO_DATE
Error: near line 176: no such function: TO_DATE
Error: near line 177: no such function: TO_DATE
Error: near line 178: no such function: TO_DATE
Error: near line 179: no such function: TO_DATE
Error: near line 180: no such function: TO_DATE
Error: near line 181: no such function: TO_DATE
Error: near line 182: no such function: TO_DATE
Error: near line 183: no such function: TO_DATE
Error: near line 184: no such function: TO_DATE
Error: near line 185: no such function: TO_DATE
Error: near line 186: no such function: TO_DATE
Error: near line 187: no such function: TO_DATE
Error: near line 188: no such function: TO_DATE
https://ideone.com/V5lmTz
language:
SQLite (sqlite 3.27.2)
created:
4 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!