1) In stored procedure when i difine
varchar(100) does this means, it takes 100 in bytes.
should i define varchar(100 char) as in database we have defined the col in tables as varchar(100 char).
The same rules apply for PL/SQL as they do for SQL. See the 'Length Semantics' section of the Oracle® Database Globalization Support Guide
If you are defining variables that represent table columns you should define them using
'tableName.columnName%TYPE' to ensure that the definitions are identical and remain so even if the table definition changes.