Insert View syntax INSERT INTO view_name(col_name) VALUES (col_value); COURSE_ID NAME DESCRIPTION DURATION PRICE 2 SQL 2 SQL course for advanced 2 week 50 4 PHP PHP course 4 week 75 5 CSS Learn CSS 2 week 20 Insert View example insert into course_view (course_id, name, description, duration, price) values (100, ‘Python’, ‘Python course’, ‘4 weeks’,…(Continue Reading)
Category: PL/SQL
Learn PLSQL Tutorial
PL/SQL Drop View
Drop View syntax DROP VIEW view_name; COURSE_ID NAME DESCRIPTION DURATION PRICE 2 SQL 2 SQL course for advanced 2 week 50 4 PHP PHP course 4 week 75 5 CSS Learn CSS 2 week 20 Drop View example DROP VIEW test_view; select * from test_view; Output: ORA-00942: table or view does not exist
PL/SQL Rename View
Rename View syntax RENAME view_name TO new_view_name; COURSE_ID NAME DESCRIPTION DURATION PRICE 2 SQL 2 SQL course for advanced 2 week 50 4 PHP PHP course 4 week 75 5 CSS Learn CSS 2 week 20 Rename View example rename course_view to test_view; select * from test_view; Output: COURSE_ID NAME DESCRIPTION DURATION PRICE 2 SQL…(Continue Reading)
PL/SQL Replace View
Replace View syntax CREATE OR REPLACE VIEW view_name AS SELECT * FROM table_name; COURSE_ID NAME DESCRIPTION DURATION PRICE 1 SQL 1 SQL course for beginners 1 week 10 2 SQL 2 SQL course for advanced 2 week 50 3 HTML5 Learn HTML 5 1 week 10 4 PHP PHP course 4 week 75 5 CSS…(Continue Reading)
PL/SQL Create View
Create View syntax CREATE VIEW view_name AS SELECT * FROM table_name; COURSE_ID NAME DESCRIPTION DURATION PRICE 1 SQL 1 SQL course for beginners 1 week 10 2 SQL 2 SQL course for advanced 2 week 50 3 HTML5 Learn HTML 5 1 week 10 4 PHP PHP course 4 week 75 5 CSS Learn CSS…(Continue Reading)