what is the difference between varchar and varchar(2)?
Answers were Sorted based on User's Feedback
Answer / swapnil
When you use varchar data type say varchar(20),
it will reserve the space of 20 bytes even length of
passing parameter is less than 20 byte. But in varchar2, it
will release the remaining space after reserving actual
passing parameter length
Is This Answer Correct ? | 11 Yes | 7 No |
Answer / srinivasa reddy k
Varchar2 is the oracle datatype
Varchar is not the oracle datatype but still oracle
supports it by converting it into varchar2
But it is not a good practice to use Varchar datatype
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / sandeep kumar
VARCHAR2 is as per the ANSI standard while VARCHAR is not.
Hence we should use VARCHAR2.
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / mohan kumar
VARCHAR--FIXED LENGTH OF DATA TYPE,MEMORY ALLOCATION WILL
NOT TAKE PLACE.
VARCHAR2--IN THIS ORACLE DATA TYPE,MEMORY ALLOCATION WILL HAPPEN
Is This Answer Correct ? | 2 Yes | 5 No |
List the types of flexfield?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What is count(*) from po_vendors(any table)?
Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CONTROL table and if I not inserted into GL_INTERFACE_CONTROL what will happen
What are the different components you should consider while defining a responsibility in oracle apps?
What is responsibility?
what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .
tell my any difficult situtation you solved in your experience in your company?
After deploying like forms,reports into server how we connect this forms,reports to web?
what are the different types of triggers in reports
tell me the scenarios of the independent in reports
P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?
9 Answers CSC, IBM, KPIT, Oracle,