Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Create a New View
How To Create a New View? - Oracle DBA FAQ - Understanding SQL DDL Statements
✍: FYIcenter.com
You can create a new view based on one or more existing tables by using the CREATE VIEW statement as shown in the following script:
CREATE VIEW employee_department AS SELECT e.employee_id, e.first_name, e.last_name, e.email, e.manager_id, d.department_name FROM employees e, departments d WHERE e.department_id = d.department_id; View created. SELECT first_name, last_name, department_name FROM employee_department WHERE manager_id = 101; FIRST_NAME LAST_NAME DEPARTMENT_NAME -------------------- ------------------- ---------------- Nancy Greenberg Finance Jennifer Whalen Administration Susan Mavris Human Resources Hermann Baer Public Relations Shelley Higgins Accounting
2007-04-22, 4771👍, 0💬
Popular Posts:
What is continuous and staged representation? CMMI contains 25 key process areas which organization ...
What are the five levels in CMMI? There are five levels of the CMM. According to the SEI, Level 1 – ...
How To Assign Debug Privileges to a User? - Oracle DBA FAQ - Introduction to Oracle SQL Developer In...
How To Select an Oracle System ID (SID)? - Oracle DBA FAQ - Creating New Database Instance Manually ...
How to make elements invisible? Change the "visibility" attribute of the style object associated wit...