Q: What happened when we can insert less number of values into the table as the record?

Ex: table ==> row ==> 6 columns
inserting 5 values out of 6

=> When we can enter the less values than the original size of the record/tuple/row, then we can get an error with a message "not enough values".

Ex: 
insert into customerInfo(SNo, CId, CName, Age, Gender, Location) values(1, 123456,'Sathwik', 27, 'Vizag');

insert into customerInfo values(1,121314,'Satish','Male','Hyderabad');

insert into customerInfo values(&SNo, &CId, &CName, &Age, &Location);

output: "not enough values".

Note:
----
If we can insert more number of values than the size of the row we can get an error message "too many values".

================================================
Q-2: Write a SQL query to display all available tables in the Database account?
Ans:
select * from all_tables;

or

select * from user_tables;

or 
select * from tab;

==============================================
Q-3: name varchar2(10);
name = "ravi" ==> correct
4-bytes

name = "abcdefghijkl"

=> if we can enter more characters than the size of varchar, we can get an error message
"The size of varchar as n but you have entered as m"

======================================================

Update the table data:
======================
=> to update the table data which we have already inserted, we can use one of the DML command named as "update".
=> update can be used in two ways:
	1) update on the particular field
	---------------------------------
	-> to update the particular column of the table, we need a condition.
	-> In SQL, to define the condition, we need to use "where" clause.
	-> while updating the table, to set new values for the existing fields, we required "set" clause.
	Syntax:
		update <table-name> set <col1> =  <nval1>,<col2> = <nval2>,.... where <condition>;

Ex: 
update customerInfo set location = 'Bangalore',CId = 192939 where CName = 'Satwik';

	2) update on the entire table
	------------------------------
	=> here, no need of where clause.
	Syntax:
		update <table-name> set <col1> = n-val1, <col2> = n-val2,...;

Ex:
update customerInfo set location = 'Hyderabad';

==============================================
Set clause:
-----------
=> Set clause can be defined with "set" keyword.
=> It required in:
	1) to formatting the table
	2) while updating the table

Where clause:
-------------
==> where is a keyword we can use to define the "condition" within the query based on the application requirement.