INTERVIEW QUESTIONS
ORACLE
PL-SQL
DETAILS
Question: What are the datatypes a available in PL/SQL ?
Answer: Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN. Some composite data types such as RECORD & TABLE.
|
Question:
What are the datatypes a available in PL/SQL ?
Answer:
Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN. Some composite data types such as RECORD & TABLE. Source: CoolInterview.com
1. Character Datatypes: char(size), nchar(size), varchar2(size), nvarchar2(size), long, raw, longraw 2. Numeric Datatypes number(p,s), numeric(p,s), float, dec(p,s), decimal(p,s), integer, int, smallint,real, double precision 3. Date/Time Datatypes: date, timestamp, timestamp with local time zone, timestamp with time zone, interval year to month, interval day to seconds 4. LOB data types: bfile,blob,clob,nclob 5. Rowid Data types: rowid,urowid Source: CoolInterview.com
Answered by: RadhaMadhavi | Date: 10/28/2009
| Contact RadhaMadhavi
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|