Search This Blog

Monday, November 8, 2021

Difference Between Table Name With Quotation mark and Without Quotation mark (")

Difference Between Table Name test and "test" 

Look at the below table. There is tow table named test and "test". You can create same name two table in a database and schema. But why ? What is the difference  ? 

Actually Oracle database is case sensitive in this case. But this issue is little deferent. Oracle database take as smaller latter when table name with Quotation mark ("test") .  On the other hand without Quotation mark table name Oracle database take as capital letter. 

When we do a query like (select * from test) Oracle database take the table name in capital letter and do the query.  So there is a case sensitive issue occurred. 

So Finally, good practice is creating table without Quotation mark. If you create table with Quotation mark then every time you have to write Quotation mark when you will do query.   

test

“test”

create table test (

id number,

name varchar2(20),

address varchar2(500)

)

create table "test" (

id number,

name varchar2(20),

address varchar2(500)

)

insert into test values (1,'Qaium','Address') ;

 

insert into "testvalues (1,'Halim','Motron') ;

 

select * from test ; 

select * from "test" ;


No comments:

Post a Comment

Restrict File Upload by File Type in Oracle Apex

If you want to restrict file upload by file type/extension/format you can follow the below steps.  Goto File Browser Item --> Advanced --...