If a View on a single base table is manipulated will the changes be reflected on the base table ?
If changes are made to the tables which are base tables of a view will the changes be reference on the view.
Latest Answer: sorting mean puting the value in a particular order , could by alhphabaticgouping mean making a group of same type of values and displaying a single row for that groupexample select deptno, sum(sal) from emp group by deptno order by 1;first the ...
Latest Answer: LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN ...
Latest Answer: We can be selective in joins query. e.g.select e.name,d.cityfrom employee einner join detail don e.employee_id = d.employee_id and d.city in('aaa',bbbb','cccc') ...
Answer posted by Scott on 2005-05-25 18:43:29: SELECT rownum, rowid FROM sometable
Latest Answer: Besides these, the other pseudo columns are: user,uid ...
Latest Answer: SQL%ISOPEN exists. Oracle always evaluates this to FALSE as PL/SQL closes implicit cursors immediately after they are executed. ...
Latest Answer: Explicit & Implicit crusors have same attributes. ...
Latest Answer: 1. DDL: Data Definition Language2. DML: Data Manipulation Language3. TCL: Transaction Control Language4. DCL: Data Control Language5. DQL: Data Query Language ...
Latest Answer: JOIN:it is nothing but a query used to retrieve data from more than two tables. ...
Latest Answer: Data Definition Language: Create, AlterData Modification Language: Update,insert, Delete, TruncateData Control Language: Commit, Rollback ...
View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>
Go Top
