Latest Answer: Can anyone tell me the diffrence between CHAR and VARCHAR2(1)...why do we use char when we can give it as varchar2(1)..????Thanks in advance.. ...
Latest Answer: There are only three tablespaces as follows:-1.Permanent tablespace2.Undo tablespace3.Temperory tablespace ...
Latest Answer: These are the querys:- FOR Odd number of records: select * from emp where (rowid ,1) in (select rowid, mod(rownum,2) from emp); FOR Even number of records: select * from emp where (rowid ,0) in (select rowid, mod(rownum, 2) from emp); try......................... ...
Latest Answer: The number which have precesion can be spelled in words by this way..SELECT DECODE(SUBSTR(LPAD('1256932.1',DECODE(INSTR('1256932.1','.'),0,11,DECODE(LENGTH('1256932.1')-INSTR('1256932.1','.'),1,13,14)),'0'),1,4),'0000','',TO_CHAR(TO_DATE('01-12-'||SUBSTR(LPAD('1256932.1',DECODE(INSTR('1256932.1','.'),0,11,DECODE(LENGTH('1256932.1')-INSTR('1256932.1','.'),1,13,14)),'0'),1,4),'DD-MM-YYYY'),'YYYYSP')||' ...
Latest Answer: 5. The query of the view shoud not consist of any aggregate funtion 6. The query shoud not consist of any subquery 7 And the other option is we can use the instead of trigger to update the Table/s based up on the dml operation issued over the ...
Latest Answer: Integrity constraint is that which depend upon the parent and child relationship
in which parent column have the primary constraint and child column have the foreign
key constraint.
You cannot delete the any value from column that have foreign key ...
Latest Answer: for - values it return (-1);for 0 it return (0);for + values it return (+1); ...
What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint
Latest Answer: select deptno,sum(sal) from emp ...
Latest Answer: if a view based on one table or multiple table matter is it should contain all not null columns and additionaly no calculated column then ant DML statement will cause changes in base table. ...
View page << Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
Go Top
