Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between CHAR and VARCHAR2? If
VARCHAR2 serves the uses of CHAR why CHAR is still used and
not been discarded yet?
- 9 Answers
- 18663 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / hannan
in char it allocates the memory space as static where as in
varchar2 it allocates the memory space as dynamic
OR
char is a space mapping function where as in varchar2 it is
not mapping the space it occupies the exact size of the
string
| Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
What is the difference between sql and isql*plus?
How do I write a cron which will run a sql query and mail the results to agroup?
What is the starting oracle error number? What is meant by forward declaration in functions?
How do I remove sql developer from windows 10?
Does truncate remove indexes?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Which is better cte or subquery?
What does the hierarchical profiler does?
Can we write ddl statements in functions?
What is trigger and stored procedure in sql?
What are operators available in sql?
How to read xml file in oracle pl sql?
what does the t-sql command ident_current does? : Transact sql
What is sql used for?
What has stored procedures in sql?
