query to find the maximum no persons with same age(age
colomn) from emp table
Answer / krishnakumar
select max_age,age
from
(select count(age) max_age,age from emp group by age order
by max_age desc)
where rownum < 2
Is This Answer Correct ? | 1 Yes | 0 No |
how to truncate date and get only time part 9:20:00
How to convert characters to numbers in oracle?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
Give syntax for SQL and ORACLE joins.
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
How to create a new table in oracle?
What is a directory object?
How to execute the package in oracle?
Explain the use of record length option in exp command.
How do we get field detail of a table?