to_date() and insert statement : Insert « Insert Update Delete « Oracle PL/SQL Tutorial





SQL>
SQL> create sequence s_emp_id
  2  start with 1000;

Sequence created.

SQL>
SQL>
SQL> create table gift(
  2           gift_id                integer         primary key
  3          ,emp_id                integer
  4          ,register_date              date not null
  5          ,total_price        number(7,2)
  6          ,deliver_date           date
  7          ,deliver_time           varchar2(7)
  8          ,payment        varchar2(2)
  9          ,emp_no                 number(3,0)
 10          ,deliver_name           varchar2(35)
 11          ,message        varchar2(100)
 12  );

Table created.

SQL>
SQL> insert into gift(gift_id,emp_id,register_date,total_price,deliver_date,deliver_time,payment,emp_no,deliver_name,message)values
  2                 (1,1,'14-Feb-1999', 123.12, '14-Feb-1999', '12 noon', 'CA',1, null, 'Happy Birthday to you');

1 row created.

SQL> insert into gift(gift_id  ,emp_id ,register_date ,total_price ,deliver_date ,deliver_time ,payment ,emp_no,deliver_name ,message)values
  2                 (2,1,'14-Feb-1999', 50.98, '14-feb-1999', '1 pm', 'CA',7, 'name1', 'Happy Birthday');

1 row created.

SQL> insert into gift(gift_id  ,emp_id ,register_date ,total_price ,deliver_date ,deliver_time,payment ,emp_no,deliver_name ,message )values
  2                 (3, 2,'14-Feb-1999', 35.99, '14-feb-1999', '1 pm', 'VS',2, 'Tom', 'Happy Birthday');

1 row created.

SQL> insert into gift(gift_id  ,emp_id ,register_date ,total_price ,deliver_date ,deliver_time,payment ,emp_no,deliver_name ,message )values
  2                 (4, 2,'14-Feb-1999', 19.95, '14-feb-1999', '5 pm', 'CA',2, 'Mary', 'Happy Birthday');

1 row created.

SQL> insert into gift(gift_id  ,emp_id ,register_date ,total_price ,deliver_date ,deliver_time,payment ,emp_no,deliver_name ,message)values
  2                 (5, 6,'4-mar-1999', 10.95, '5-mar-1999', '4:30 pm', 'VS', 2, 'Jack', 'Happy Birthday');

1 row created.

SQL>
SQL>
SQL> insert into gift (gift_id, emp_id, register_date, payment)
  2  values (s_emp_id.nextval, s_emp_id.currval,
  3    to_date('01/15/2000', 'mm/dd/yyyy'), 'VS');

1 row created.

SQL>
SQL>
SQL> drop table gift;

Table dropped.

SQL>
SQL> drop sequence s_emp_id;

Sequence dropped.

SQL>










4.1.Insert
4.1.1.Adding Rows Using the INSERT Statement
4.1.2.Omitting the Column List
4.1.3.Insert value for specific columns
4.1.4.Specifying a Null Value for a Column
4.1.5.Including Single and Double Quotes in a Column Value
4.1.6.Insert double quote
4.1.7.Use trunc in insert statement
4.1.8.Combine three tables with 'insert into statement'
4.1.9.Insert default value
4.1.10.Truncate sysdate in insert statement
4.1.11.Adding Multiple Rows to a Table
4.1.12.Conditional INSERT Statement
4.1.13.to_date() and insert statement
4.1.14.To insert records into a table using a subquery: