adspace


Explain oracle data types with examples?

Answer Posted / Ram Kumar Singh

{"data_types": [n {"name": "CHAR", "description": "Fixed-length string, containing a specified number of characters. For example: CHAR(5) contains a string of length 5"},n {"name": "VARCHAR2", "description": "Variable-length string, can contain up to a maximum of 4000 characters. For example: VARCHAR2(10) can contain a string of maximum length 10"},n {"name": "NUMBER", "description": "Numeric data type with a precision (number of significant digits) and scale (number of digits to the right of decimal point). For example: NUMBER(5,2) has precision 5 and scale 2"},n {"name": "DATE", "description": "Stores date information in the YYYY-MM-DD format. For example: DATE(2021-08-31)"},n {"name": "RAW", "description": "Binary data type, stores fixed-length bytes. For example: RAW(2) can store 2 bytes of binary data

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Design database draw er diagram for a certain scenario ?

4654


How to select all columns of all rows from a table in oracle?

1127


What is oracle latest version?

1173


How to write a left outer join with the where clause in oracle?

1151


How to put more than 1000 values into an oracle in clause?

1113


How to start an oracle instance?

1103


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1955


How to use values from other tables in update statements using oracle?

1156