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 2 SQL course for advanced 2 week 50
4 PHP PHP course 4 week 75
5 CSS Learn CSS 2 week 20