Author: Dev

Oracle PL/SQL collections and records are data structures that allow for the storage and manipulation of multiple values or rows of data within a single variable or object. Collections Collections are a group of similar data elements, such as a group of strings or numbers. There are three types of collections: arrays, lists, and associative…(Continue Reading)

A PL/SQL view is a virtual table that contains data from one or more tables. PL/SQL Views are used to provide security or simplify complex queries. In this article we have a list of operations that can be performed on PL/SQL Views. Creating a View To create a view in Oracle database, you use the…(Continue Reading)

Delete View syntax DELETE FROM view_name WHERE condition; 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 100 Python Python course 4 week 89 Delete View example delete from course_view where course_id=100; commit; select *…(Continue Reading)

Update View syntax UPDATE view_name SET col_name WHERE condition; 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 100 Python Python course 4 week 80 Update View example update course_view set price=89 where course_id=100; commit;…(Continue Reading)

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)