CODEWITHSUNDEEP
oracle-database
Joze Cigl
Joze Cigl

Reputation: 21

how to specifically define table name in Oracle SQL

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.

Upvotes: 0

Views: 71

Answers (1)

xQbert
xQbert

Reputation: 35323

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!

Upvotes: 1

Related Questions