Hi Guys,

I am new to this forum & new to database field aswell. May be this is a silly question from me but i am struck with this issue. I am trying to execute a insert statement and the query keep on executing looks like its not gonna end. Even if i select * from the table which i am trying to insert values it still says 'Executing Query'. Can anyone can help me with this.

Regards,

Kishor

what is the query that you are executing ?

What exectly are you doing??

see the general format of insert the values and the try................

create table st(roll number(3),name varchar2(20),course varchar2(20));

inserting values into the table st

insert into st values(1,'DAVE',null);
insert into st values(2,'PETER','oracle');

null - if u want to insert empty value into the column
don't put null in quotes,it will become value

to check whether values inserted into table

select * from st;

Check the syntax............

Syntax of inserting values into a table :

insert into table {table name} values(2,'John',10,'lahore');

After this the values get inserted into the various coulmns of the table in question.

For checking the results please use the Select * from {table} query.

Give me a shout if you have a doubt.

Thanks!

hi everyone , i m also new here

i have a basic knowledge of SQL

what is the difference between SQL & MYSQL