How to run a query from SQL in RJDBC Oracle Database?

Question

I can achieve the connection to my oracle database. I have no problem to obtain a table from the base with the query:

SELECT * FROM TABLE1

but when i write:

SELECT * , COLUMN1 FROM TABLE1

it shows error:

in .verify.JDBC.result(r, "Unable to retrieve JDBC result set for ", : Unable to retrieve JDBC result set for select *; column1 FROM Table1 (ORA-00911: carÃ¡cter no vÃ¡lido )

Any suggestions?

Assuming you already have COLUMN1 in your resultset, can you try like: select *,COLUMN1 as mynewcolumn from table1 — Eray Balkanli
– Eray Balkanli, Commented May 16, 2019 at 19:42

Littlefoot · Accepted Answer · 2019-05-16 20:00:56Z

2

Use a table alias, e.g.

This doesn't work (as you already know it):

SQL> select *, dname from dept;
select *, dname from dept
        *
ERROR at line 1:
ORA-00923: FROM keyword not found where expected

But this works OK:

SQL> select d.*, d.dname from dept d;

    DEPTNO DNAME          LOC           DNAME
---------- -------------- ------------- --------------
        10 ACCOUNTING     NEW YORK      ACCOUNTING
        20 RESEARCH       DALLAS        RESEARCH
        30 SALES          CHICAGO       SALES
        40 OPERATIONS     BOSTON        OPERATIONS

SQL>

answered May 16, 2019 at 20:00

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

How to run a query from SQL in RJDBC Oracle Database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related