| |
|
How to create a table in SQL? How to set a default value for a column?
Below is the syntax to create a table in SQL:
create table t_tablename
(column1 number(5) primary key,
column2 varchar2,
column3 varchar2 default = 'Some Value');
SQL Queries
SQL
Create Table
DDL, Create, Alter, Drop commands
DML, Select, Insert, Update, Delete
Create Database
ACID Rules
Dual Table
NULL
Join, Inner, Outer, Left, Right, Full, Cartesian, Natural, Equi
Table, View and a Synonym?
Execute
Function
Stored Procedure
Syntax Stored Proc
Stored Procedure Vs. Function
| |