Delimiting keywords or special characters

Delimit the table or column name with special characters

Select * from firm's_address;

Select * from "firm's_address";

Delimiting table or column name which is a reserved word as well

Say you have a table named table or you want to create a table with name which is also a keyword, You have to include the name table in pair of double quotes "table"

Select * from table; Above query will fail with syntax error, where as below query will run fine.

Select * from "table";

Contributors

Topic Id: 6553

Example Ids: 22424,22425

This site is not affiliated with any of the contributors.