Latest Answer: Referential integrity constraint is that which depend upon the parent and child relationship. In this one of the column have the primary key constraint
and one of the column of another table have the foreign key constraint. So you cannot delete ...
Latest Answer: only one long col allowed in a table. ...
Latest Answer: if index is create by primary key /unique key constraint thenby droping the constriant , the index will be droped automaticallyelsedrop index ...
Latest Answer: NVLselect empno, ename, mgr, nvl(to_char(mgr),'no manager') from emp; ...
Latest Answer: TOO_MANY_ROWSNO_DATA_FOUNDINVALID_CURSORSCURSOR_ALREADY_OPENDUP_VAL_ON_INDEX ...
Latest Answer: The Address Field of the index is called ROW IDFormat: BBBBBBB.RRRR.FFFFFFFF: Unique Number given by oracle engine to each Data fileBBBBBBB: each Data File is further divided in Data BlocksRRRR: Data Blocks can store one or more Records ...
Latest Answer: In correlated subqueries, the information from the outer select statement participates as a condition in the inner select statement.Eg : Select deptno, ename, sal from emp a where sal> (select avg(sal) from emp b where ...
If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE
Latest Answer: Quote A ROWID is created by Oracle for each new row in every table, it is a pseudo column that has a value for every row in a table. The ROWID gives us the physical address of a row and is the fastest way to access any row. The ROWID contains 3 ...
Latest Answer: ON DELETE CASCADE option permits deletions of referenced key values in the parent table and automatically deletes dependent rows in the child table to maintain referential integrity. ...
View page << Previous 5 6 7 8 [9] 10 11 12 13 14 Next >>
Go Top
