Latest Answer: ALTER TABLE Table_1 ALTER COLUMN test1 nchar(20) ...
Latest Answer: select from(select from orderby sal asc) where row num
Latest Answer: 253 is not prime, it is divisible by 11 and 23. So the ans. is 251. ...
Latest Answer: The only rule that is not satisfied by oracle db is the systamatic treatment of NULL values. NULL in oracle is treated as absence of a value or unknown status (in case of comparision of values) and it doesn't have any systamatic representation. In ...
Latest Answer: 9i it supports the Jdeveloper and Application server where 8i doesn't ...
Latest Answer: Dear Friends,Please try this and confirm,((select * from emp where (rowid,1) in (select rowid,mod(rownum,2) from emp)) Minus (select * from emp where (rowid,0) in (select rowid,mod(rownum,3) from emp)))union(select * from emp where (rowid,3) in (select ...
Latest Answer: select rownum,empno from emp group by rownum,empno having mod(rownum,3)=1; ...
Latest Answer: alter table table_name drop column column_name;Ritika ...
Latest Answer: Hi,Nested Tables are collector objects (only attributes, i.e. no behaviour defined), that can be re-used in the same way as a class in java or c++ (without functions / procedures). In RDBMS, its mainly used for - 1. Reusability - Containment ...
select level, max('col_name') from my_table where level = '&n' connect by prior ('col_name') >'col_name')group by level;Example:Given a table called emp with
Latest Answer: SELECT MAX () FROM WHERE IN (SELECT TOP n FROM ORDER BY ASC)OR SELECT MIN () FROM WHERE IN (SELECT TOP n FROM ORDER BY DESC) ...
View page << Previous 7 8 9 10 [11] 12 13 14 15 16 Next >>
Go Top
