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 |
What are the different windows events activated at runtime ?
Who i will insert 1 lacks record in a Database table
How to write date and time literals in oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How to concatenate two text values in oracle?
What are the commands youd issue to show the explain plan for select
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What are the general rules on data consistency?
Will you be able to store pictures in the database?explain.
How to open and close an explicit cursor in oracle?
how to delete all duplicate records from a table using subquery?
What is pragma autonomous transaction in oracle?