Some Basic Doubts about HAVING CLAUSE,SYSDATE,LONG datatype

[lucky10101]

1) depends how you are doing it, why dont you say?
3) sysdate if a function which returns a date
4) yes

1} create table t2 as select * from t1;
-one of the colum in t1 is of LONG datatype
-if i drop that column with LONG datatype then i am able to create a duplicate table
2)if SYSDATE is a function then where are the paranthesis. Is there a chance of SYSDATE to be a pseudo column