Wrong SQL statement in Oracle 11g

Question

I want to get the value SESSIONID from this table:

CREATE TABLE SESSIONSLOG(
  SESSIONID VARCHAR2(30 ) NOT NULL,
  USERNAME VARCHAR2(30 ),
  IPADDRESS VARCHAR2(30 ),
  LOGINTIME TIMESTAMP(6),
  LOGOUTTIME TIMESTAMP(6)
)
/

I tried this SQL query:

SELECT SESSIONID FROM ACTIVESESSIONSLOG

But I get this error message:

ORA-00904: "SESSIONID": invalid identifier
00904. 00000 -  "%s: invalid identifier"
*Cause:    
*Action:
Error at Line: 1 Column: 7

How I can fix this?

Jon Skeet · Accepted Answer · 2012-05-24 15:50:52Z

3

You're querying the wrong table:

CREATE TABLE SESSIONSLOG

...

SELECT SESSIONID FROM ACTIVESESSIONSLOG

ACTIVESESSIONSLOG is not the same as SESSIONSLOG.

answered May 24, 2012 at 15:50

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rahul · Accepted Answer · 2012-05-24 15:59:04Z

2

You are querying wrong table ... table should be SESSIONSLOG

SELECT SESSIONID FROM SESSIONSLOG

answered May 24, 2012 at 15:59

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Comments

SKL · Accepted Answer · 2012-05-24 16:20:30Z

1

@user1285928 you are not supposed to use " ACTIVESESSIONSLOG " .

Instead Use SESSIONSLOG. Also use the delimiter symbol ;

SELECT SESSIONID FROM SESSIONSLOG;

answered May 24, 2012 at 16:20

SKL

776 bronze badges

Collectives™ on Stack Overflow

Wrong SQL statement in Oracle 11g

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related