#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2012
    Posts
    4
    Rep Power
    0

    SQL Syntax Error


    Hello,

    I'm working on Oracle SQL Developer: ODMiner. I keep getting a syntax error with the following code,

    CREATE TABLE FINAL_WEBLOG AS
    select SESSION_DT, C_IP, CS_USER_AGENT,
    LISTAGG(WEB_LINK, ' ')
    WITHIN GROUP (ORDER BY C_IP, CS_USER_AGENT) "WEB_LINKS",
    FROM WEBLOG_VIEWS
    GROUP BY C_IP, CS_USER_AGENT, SESSION_DT
    ORDER BY SESSION_DT


    I understand if it's the semicolon that is missing after "FROM WEBLOG_VIEWS", but I'm not sure on how I can rephrase it.

    The error I got was,

    Error at Command Line:5 Column:2
    Error report:
    SQL Error: ORA-00936: missing expression
    00936. 00000 - "missing expression"
    *Cause:
    *Action:
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2012
    Posts
    4
    Rep Power
    0
    Found my mistake..

IMN logo majestic logo threadwatch logo seochat tools logo