Hi, I have a question about how to insert data
in composite types! Imagine the exemple: CREATE TYPE t_time AS
( a date, b date ); CREATE TABLE salary
( salary
numeric(10,2), t_date
t_time ); I know that if I want to insert data in the table
SALARY I just have to do like: INSERT INTO
salary VALUES (1000.00, ‘(2006/10/10, 2006/12/10)’); But if I have another table: CREATE TABLE
employee ( employee_id
int, name
varchar(30), emp_salary
salary ) How can I insert a single row in this table??? Thanks in advamce! |
- [SQL] Inserting data in composite types! Rodrigo Sakai
- Re: [SQL] Inserting data in composite types! Markus Schiltknecht
- Re: [SQL] Inserting data in composite types! Shane Ambler
- Re: [SQL] Inserting data in composite types! imad
- RES: [SQL] Inserting data in composite types! Rodrigo Sakai
- Re: RES: [SQL] Inserting data in composit... Richard Broersma Jr