DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Some Basic Doubts about HAVING CLAUSE,SYSDATE,LONG datatype

  1. #1
    Join Date
    Jul 2009
    Posts
    10

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    1) depends how you are doing it, why dont you say?
    3) sysdate if a function which returns a date
    4) yes

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    2) That's why Davey answered "Yes" to question #4
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    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.

  4. #4
    Join Date
    Jul 2009
    Posts
    10
    Quote Originally Posted by davey23uk View Post
    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

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    sysdate is a built in function which returns a date, your obsessions with parenthesis is worrying

  6. #6
    Join Date
    Jul 2009
    Posts
    10
    Quote Originally Posted by davey23uk View Post
    sysdate is a built in function which returns a date, your obsessions with parenthesis is worrying
    Thanks Davey for replying
    Generally for functions we have paranthesis so i thought SYSDATE is not a function ok now i will go with the confirmation that SYSDATE is a function

    Davey can you please help me out with the first question about creating a duplicate table which consist of LONG datatype

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width