OracleByAjay

Bank Schema DROP TABLE customer_master; DROP TABLE branch_master; DROP TABLE account_master; DROP TABLE transaction_master; DROP TABLE loan_details; CREATE TABLE customer_master( CUSTOMER_NUMBER VARCHAR2(6), FIRSTNAME VARCHAR2(30), middlename VARCHAR2(30), lastname VARCHAR2(30), CUSTOMER_CITY VARCHAR2(15), CUSTOMER_CONTACT_NO VARCHAR2(10), occupation VARCHAR2(10), CUSTOMER_DATE_OF_BIRTH DATE, CONSTRAINT customer_custid_pk PRIMARY KEY (CUSTOMER_NUMBER)); CREATE TABLE branch_master( branch_id VARCHAR2(6), branch_name VARCHAR2(30), branch_city VARCHAR2(30), CONSTRAINT branch_bid_pk PRIMARY KEY (branch_id)); CREATE TABLE account_master (account_number VARCHAR2(255), customer_number VARCHAR2(255), branch_id VARCHAR2(255), opening_balance number(20), account_opening_date DATE, account_type VARCHAR2(25), account_status VARCHAR2(10), PRIMARY KEY (account_number), FOREIGN KEY (customer_number) references customer_master(customer_number), FOREIGN KE...

Creating a Cluster: Example  CREATE CLUSTER emp_dept    (deptno NUMBER(2)); Cluster Keys: Example  CREATE INDEX idx_emp_dept ON CLUSTER emp_dept; Adding Tables to a Cluster: Example  CREATE TABLE dept_cluster    CLUSTER  emp_dept  (deptno)    AS SELECT * FROM dept ; Adding Tables to a Cluster: Example  CREATE TABLE emp_cluster    CLUSTER  emp_dept  (deptno)    AS SELECT * FROM emp; Query the cluster tables; select * from emp_cluster; select * from dept_cluster;