0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
How many bytes does number datatype occupy in oracle?
4
What is the best datatype for storing your birthday?
in Unix: the datatype is "Date" in C++: the datatype is "char"
What is the best datatype for storing birthdays?
in Unix: the datatype is "Date" in C++: the datatype is "char"
What is collection in oracle 11g?
Collection is a composite datatype in oracle and it can also be called as pl/sql table which is used to store collection of similar datas as like an array of C.There are three types in collections 1.Associative array 2.Nested Table 3.Varray
What is 11g in oracle 11g?
Collection is a composite datatype in oracle and it can also be called as pl/sql table which is used to store collection of similar datas as like an array of C.There are three types in collections 1.Associative array 2.Nested Table 3.Varray
Write a program that show size of datatype?
sizeof(datatype)
What is mean by parse in java?
It is used to convert the value of one datatype into a value of another datatype. Example- Integer.parseInt(in.readLine); It converts given value to Integer datatype.
What is datatype of pointers?
pointer
C program to implement tower of hanoi using array implementation of stack abstract datatype?
stack abstract datatype
What is a view in oracle?
It is a a virtual table created for raw users on the sport eg:your atm reciept when you request for balance information
What are the Large object types supported by Oracle?
LONG, LONG RAW, BLOB, CLOB, NCLOB. Consult the attached link.
Different between oracle datatypes char20 and varchar20?
In Oracle, the char(20) datatype is a fixed length character string. It will always use 20 characters in the block. If the value contained in the field is less than 20 characters, it will be padded on the right (or the left, depending on coding) with spaces. In Oracle, the varchar(20) datatype is a variable length character string. It will use betwen 1 and 21 characters in the block, 1 for the length, and 0-20 for the data. Its effective length can range between 0 and 20 characters. Note, however, that a string of length 0 is indistinguishable from a null value. This is a deviation from the SQL standard that Oracle acknowledges, but fixing it would break too much existing code. Note also that comparing a char against a varchar is problematic. With the trailiing spaces, the char is not the same as a varchar containing the same characters. Predicates involving these mixed types should use the rtrim expression on the char datatype. (Example: while rtrim(mycharvalue) = myvarcharvalue) Note also that varchar is obsolete. Current code should use varchar2, such as varchar2(20).
