Oracle data types examples

Database
Oracle

Oracle data types examples

This tutorial will help you to learn the uses of major data types in Oracle. Example-1: Use of char, varchar2 and Date data types Create a table named members that consists of 5 fields, acc_id, acc_name, acc_type, acc_nid, acc_create_date. acc_id and acc_nid char and other fields are varchar. CREATE TABLE members ( acc_id CHAR(10), acc_name VARCHAR2(50), acc_type VARCHAR2(7), […]

Read More