![]() Insert into studentA(stud_id, stud_name, stud_city) values(104,'Sameer','London') Insert into studentA(stud_id, stud_name, stud_city) values(103,'Pooja','London') Insert into studentA(stud_id, stud_name, stud_city) values(102,'Johan','Mumbai') ![]() In the above syntax, we use to insert into a statement to insert the records into the specified table, here insert into keyword is mandatory, specified table name means actual table name, and inside the bracket, we need to provide the column names and finally, we need to provide the different values with respect the column name as per our requirement as shown in the above syntax.Įxample insert into studentA(stud_id, stud_name, stud_city) values(101,'Jenny','Mumbai') ![]() Insert into specific table name(colm 1, colm 2, ……colm N) values(col value1, colm value 2,….colm value 3) When we need to insert the records into the table, we must require the table name, column name, and values for a column. By using this command, we can insert the different records into the specified table that we want. This is the second query, or we can say that command in PL/SQL. The final output of the above statement we illustrated by using the below screenshot is as follows. Inside the bracket, we can write different column names as per our requirement with different data types as shown.Įxamples create table studentA(stud_id number(10) not null, stud_name varchar2(30) not null, stud_city varchar2(30)) īy using create table statement, we created a new table name student A, with different attributes and different data types. In the above syntax, we use create table statement to create a new table here, the specified table name means the actual table name that we need to create. Create table specified table name (required colm name 1specify data type(size), required colm name 2specify data type(size),….required colm name N specify data type(size))
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |