View

Oracle SQL/PLSQL Questions & Answers:

Oracle SQL/PLSQL Questions & Answers: What is SQL statement? SQL stands for Structured Query Language that is use for updating, deleting and inserting the  information from databases. SQL is an ANSI and ISO standard and is the de-facto standard database query language. Oracle database also support this language. What are database triggers and how many […]

How to make View in Oracle?

Table No.1 CREATE TABLE GRN_MASTER ( GRN_NUM       NUMBER, GRN_DATE      DATE, SUPPLIER_ID   NUMBER, GATE_PASSS_ID NUMBER, STORE_ID      NUMBER, APPROVED_ID   NUMBER, CONSTRAINTS PK_GRN_NUM PRIMARY KEY (GRN_NUM) ); Table No.2 CREATE TABLE GRN_DETAIL ( GRN_NUM       NUMBER, SR_NUM        NUMBER, ITEM_CODE     NUMBER, ITEM_UOM      NUMBER, ITEM_RATE     NUMBER, ITEM_VALUE    NUMBER, CONSTRAINT FK_GRN_NUM_DTL FOREIGN KEY (GRN_NUM) REFERENCES GRN_MASTER(GRN_NUM) ); View: -CREATE OR REPLACE VIEW […]