Some Basic Doubts about HAVING CLAUSE,SYSDATE,LONG datatype
Good Morning Friends,I am new to this forum, I have recently joined Oracle DBA course and i have some basic doubts can you please clarify it
1)Unable to create a Duplicate table if the existing table contains the LONG datatype, What may b the reason ?
2) HAVING CLAUSE:
when we give condition in having clause in that condition we use some columns,group functions.Do this colum,Group function need to be present in SELECT,GROUP BY clause please do clarify dis doubt?
3) SYSDATE is a column or function because it doesnt use paranthesis?
4)As a DBA do we need to learn Shell Scripting, PL/SQL
Sorry friends for asking so many questions in my first post, please forgive me as we are here to learn
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
1) depends how you are doing it, why dont you say?
3) sysdate if a function which returns a date
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