DmL command || Sql Tutorial -7
DML Command Insert Command Its used to insert the record into table example- Command for inserting single record insert into <table name> values(value1, value2...) Command for inserting multiple command at a time insert into <table name> values(&col1, &col2...., &coln); whenever you enter query like this it will ask you to like this - enter a value for column1- value1.. and then hit enter - enter a value for column2- value2.. and then hit enter - enter a value for column3- value3.. and then hit enter Now it will show 1 row created if you want to create more record use / and hit enter SQL> / hit enter // it will Execute most recent query again //this will so again and so on... - enter a value for column1- value1.. and then hit enter - enter a value for column2- value2.. and then hit enter - enter a value for column3- value3.. and then hit enter // if you will miss any value here that will be inserted as NULL value Update command Used to upda