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.
>insert into student values(101, 'Vikas','Hyderabad');