Oracle Database Discussions

Hello All,

I would like to know the significance of double quotes in Oracle sql queries.

As far as I know if double quotes (" ") are used in sql queries (like create, insert etc) to define table names, column names respectively then the case sensitivity is enabled.

So what this means is that while retrieving the data using 'select' we will also have to use double quotes and in exactly the same context that was used while creating the table.

EG: create table "DoubleQuotes" (srno varchar(255))
So while fetching the data I will have to use - select * from "DoubleQuotes"

This is what all I know. If there is any other significance of double quotes or if I was wrong in any of the above notes then please let me know.

Also is it possible to use double quotes as a part of table name or column name.

EG: create table "Double""Quotes" (srno varchar(255))