Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 1)
1.
You can add a row using SQL in a database with which of the following?
Discussion:
43 comments Page 2 of 5.
Manche Shekhar said:
1 decade ago
We can add a new row into table using insert command..
We can insert a row into table in two ways:
1)implicit insertion
2)explicit insertion
We can insert a row into table in two ways:
1)implicit insertion
2)explicit insertion
Shariff said:
1 decade ago
What is implicit & explicit insertion?
Manche Shekhar said:
1 decade ago
In implicit insertion we insert specific field values:
The syntax is:
insert into <tablename>(list of columns) values(list of values);
In explicit insertion we insert all field values:
The syntax is:
insert into <tablename>values(list of values);
The syntax is:
insert into <tablename>(list of columns) values(list of values);
In explicit insertion we insert all field values:
The syntax is:
insert into <tablename>values(list of values);
Timir said:
1 decade ago
Example of inserting a row as follows:
INSERT INTO table_name VALUES ('FOR STRINGS',FOR NUMERIC VALUES);
INSERT INTO table_name VALUES ('FOR STRINGS',FOR NUMERIC VALUES);
Srinivas said:
1 decade ago
Insert into <table_name> values("&ColumnName1","&ColumnName2");
Kani said:
1 decade ago
It's a keyword.
Raj said:
1 decade ago
Insert command is only add a row in a table.
M g balaji said:
1 decade ago
Insert is a keyword in order to add the new row.
VijayNS said:
1 decade ago
Add any row in a database by using INSERT key word accessing values by using & symbol it address the values of rows.
Naidu said:
1 decade ago
We can add values into table using insert keyword.
ex:create table emp(name varchar2(20),age number(20)));
it will create emp table and now insert values into this table using fallowing insert query syntax:
insert into <tablename> values('if string or date',number);
Ex:insert into emp values('nani',25);
ex:create table emp(name varchar2(20),age number(20)));
it will create emp table and now insert values into this table using fallowing insert query syntax:
insert into <tablename> values('if string or date',number);
Ex:insert into emp values('nani',25);
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers