OCA question

[vivekmcm]

Q1.can we use long column data type in groupby and order by clause
================================
Q2.can we write the below query if yes what is the answer and how it work
select sysdate + '10' from dual

[kushi]

q)can we use long column data type in groupby and order by clause

ans)No we cannot use

[sibanjan]

================================


ANSWER OF QUESTION-2  yes,we can. It adds 10 days to the current system date and shows the result.
Ex. :  select sysdate "today's date",sysdate+'10' from dual;
  today's date SYSDATE+'
---------          ---------
30-MAR-10 09-APR-10