can we use double quotes to the column name while creating a table?? if yes, then how to insert the records into it???

Hi,

No, you can not use double quotes while creating a table.

Create a table :

create table your_table (
  id int(11) NOT NULL,
  name varchar(50) NOT NULL,
  PRIMARY KEY(id)
);

Insert data into the table :

insert into your_table(id, name) values(1, 'Bill');
insert into your_table(id, name) values(2, "Bill");

hey thanq for ur help.. but i tried with double quotes, and it worked.. it is like this
create table cust_info(id number, "name" varchar2(50))//i think double quotes is optional

insert into cust_info(1,'Bill')

Sorry, I thought that you are speaking about mysql.

Sorry again.

Sorry, I thought that you are speaking about mysql.

Me too at first, but it is also valid for MySQL...