in the sql statments in the book in fundamental 1 in lesson 8 page 8-
if someone can help i'll be happy:)

[left]
INSERT INTO employees (employee_id, 
                first_name, last_name, 
                email, phone_number,
                hire_date, job_id, salary, 
                commission_pct, manager_id,
                department_id)
VALUES		   (113, 
                'Louis', 'Popp', 
                'LPOPP', '515.124.4567', 
                SYSDATE, 'AC_ACCOUNT', 6900, 
                NULL, 205, 100);

[/left]

in this example ,insert a new employee so his hiredate will be now , for that use function called sysdate to insert the current date _date of inserting processs_
اتمنى ان يكون هذا اجابة سؤال حضرتك

تم تعديل 7 يوليو 200817 سنة بواسطة eng_dina