how to specifically define table name in Oracle SQL

Question

i have a DB which has a table named LIKE.

uppon trying to execute any query on the table, it gives me an error and i know it's because of the name which is trying to use the query keyword LIKE.

Now, i have "bypassed" this issue in MySQL by just selecting the table as

SELECT tk_oseba_id, COUNT(tk_tip_like_id) AS St_Like_haha
    FROM student999.`like`;

Now this same line wont work at `l...is there any special way to to this in oracle or how can i manipulate with the table by not using the LIKE keyword.

oracle wrap in quotes.from student9999."like" and it's case sensitive when you use the quotes. — xQbert
– xQbert, Commented Apr 19, 2017 at 18:32

xQbert · Accepted Answer · 2017-04-19 18:42:06Z

1

Oracles's counter part to mysql's back tick is quote for defining tablenames/columns.

To use a key word as a table name though I recommend against it...

wrap the table name in quotes. From student9999."like"

AND... it forces case sensitivity when you use the quotes!

answered Apr 19, 2017 at 18:42

xQbert

35.5k2 gold badges46 silver badges67 bronze badges

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

3 Comments

Joze Cigl Over a year ago

its a university db, so can help it if they make the names up.. i am also against it :) thanks

APC Over a year ago

Why is that university teachers are so determined to teach their students bad practices?

xQbert Over a year ago

Maybe so if the students encounter this situation in the real world the student know how to handle it. Can't tell you how many times I ran into a table called order when supporting ERPs for small business; or even on SO.

Collectives™ on Stack Overflow

how to specifically define table name in Oracle SQL

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related