karant

INVOICE(invoice_id, client_id,item_id) CLIENTS(id, client_name) ITEM(item_id, item_name) i want 1 table that shows: invoice_id, client_name,item_name select i.invoice_id ,c.client_name,it.item_name from invoice i, client_name c,item_name it where (i.client_id = c.client_id) AND (i.item_id = it.item_id)

select current_timestamp from dual;

Update Emp Set Sal = sal + 1000 where empno = 102

INSERT INTO EMPLOYEE VALUES ('John', 'B', 'Smith', 099999781, '09-JAN-65', 731 Fondren Houston TX', 'M', 30000, 333445555, 5); INSERT INTO EMPLOYEE VALUES ('John', 'B', 'Smith', 099999781, '09-JAN-65', '731 Fondren Houston TX', 'M', 30000, 333445555, 5);

If Test is the name oof your table having following columns REC_TEST Id_Customer Id_Apply then ALTER table Test MODIFY COLUMN Id_Customer VARCHAR2(4) alter table test add constraint test_id_ck check(Id_Customer in ('YES','NO') this will surely help u

select trunc(to_date('01-SEP-2007')-to_date('22-JUN-2007')) as "days between dates" from dual; kiran