Author: Dev

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

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)

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)

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)

The user defined exceptions are user declared exceptions in the declarative part of any PL/SQL anonymous block, subprogram or package. In the first example exception was declared in the declarative part and then the exception is triggered inside the block using RAISE. The second example use RAISE_APPLICATION_ERROR inside the block with no need to declare…(Continue Reading)