A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)
SQL> CREATE OR REPLACE VIEW myView (First_Name, Last_Name) AS
select First_Name,Last_Name
from Employee
where Salary > 2000;
View created.
SQL> drop view myView;
View dropped.
-
The solution is used to copy archivelogs from RMAN catalog. Step 1: uncatalog the required archivelogs from RMAN prompt RMAN>CHANGE ARCHI...
-
How to search on Google Tip 1: Keep it simple No matter what you're looking for, try to start with a simple search like [ whe...
No comments:
Post a Comment