Explain oracle data types with examples?



Explain oracle data types with examples?..

Answer / 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

More Oracle General Interview Questions

What are the different windows events activated at runtime ?

1 Answers   Oracle,


Who i will insert 1 lacks record in a Database table

4 Answers   TCS,


How to write date and time literals in oracle?

1 Answers  


In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1 Answers  


How to concatenate two text values in oracle?

1 Answers  


What are the commands youd issue to show the explain plan for select

2 Answers  


What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

1 Answers   Infosys,


What are the general rules on data consistency?

1 Answers  


Will you be able to store pictures in the database?explain.

1 Answers  


How to open and close an explicit cursor in oracle?

1 Answers  


how to delete all duplicate records from a table using subquery?

7 Answers   ABC, Cap Gemini,


What is pragma autonomous transaction in oracle?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)