Database Field size [message #571614] |
Wed, 28 November 2012 02:48 |
|
hissam78
Messages: 193 Registered: August 2011 Location: PAKISTAN
|
Senior Member |
|
|
Dear all,
We have Employee table, there is a field name Employee_no. field size is 6.
can we restrict some one not to increase or decrease the field size of Employee_no. even User has admin role.
is there any way to restrict admin user that he should not allow to enter the value of field more or less than 6 characters through Toad or SQL Plus 8.0.
------------------------------------------------------
for example
field: employee_no
feild_size: 6
field_type: Varchar2
When we enter Employee no A000001(7 digit) then database not allowed to update because its field size is 6 characters we want to restrict admin user in Toad or SQL Plus 8.0 because he is Toad and SQL Plus user.
-------------------------------------------------------
thanx & regards,
[Updated on: Wed, 28 November 2012 02:57] Report message to a moderator
|
|
|
|
|
|
|
|
|