how to insert record in table in oracle


How to insert record in table in oracle

We can insert data in two ways.

Numeric value will be inserted without quote and string value will be inserted within single quote in oracle.

How to insert all column record

>insert into table_name values(Number_value,'String Value');

above command is used when developer wants to insert all column record in table.

How to insert few column record

>insert into table_name(Column_Name,Column_Name) values(Number_value,'String Value');

Above command used when developer does not want to insert all field in table.

Example

>insert into student values(101, 'Vikas','Hyderabad');






Full-stack web and mobile app development company Contact Us : Skype: indore.webcoder Email: info@w3sparks.com Sales: +91 8085506229