Oracle

How to Create a Table in Oracle

Here is an example of how to create a table in Oracle. The table’s name is “sample_table” and has 3 columns.  CREATE TABLE SAMPLE_TABLE( SOME_STRING VARCHAR2(50 CHAR),  –The “CHAR” part multiplies the precision (50) by 4.  This means the storage for the column is 200. SOME_NUMBER NUMBER(32,12),  –This column has a total precision of 32, [...]