 Related Questions Latest Answer : Of course Varchar2 is there to maintain variable length of columns. It keeps an internal pointer to maintain Variable length that means it wastes two bytes to keep first and last index where column starts and Calculates for each DML operation against ... Latest Answer : In case of varchar it store upto 2000 bytes and in case of varchar2 it stores 4000 bytes that is the basic difference between varchar and varchar2. ... Read Answers (21) | Asked by : Srinu Latest Answer : The varchar2(30) will take 30 bites. Because the size is specified as 30. if you entered a data of only 20 chars the remaining 10 will be transformed to the other field or row. By this the wastage of the disk space can be minimised. ... SQL>DECLARE 2 dayofweek VARCHAR2(200); 3 BEGIN 4 SELECT TO_CHAR(sysdate,'Day') INTO dayofweek FROM DUAL ; 5 6 IF dayofweek = 'Tuesday' 7 THEN 8 Latest Answer : TO_CHAR(sysdate,'Day') is always return day name with some blank space, So its better to use TRIM function to exact match.Like TRIM(TO_CHAR(sysdate,'Day'))Or You can match initial 3 character in the by using substr function. ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
