Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
I have the following query that returns an error and i want to know what is the problem ? SELECT last_name, first_name FROM employees WHERE salary = (SELECT salary FROM employees WHERE department_id = 30); the error returned is : (SELECT salary FROM employees WHERE department_id ...
I am working on Oracle database 11g, and facing an issue while trying to execute the following query: SELECT d.department_name, e.manager_id, l.location_id, sum(e.salary) FROM departments d, employees e, locations l WHERE d.department_id = e.department_id AND e.manager_id = d.manager_id (+) AND l.location_id = d.location_id (+) GROUP BY ...
I face this error when I want to execute this block of code in an anonymous pl/sql block: DECLARE BEGIN SELECT last_name INTO v_last FROM employees; dbms_output.put_line('v_last is :' || v_last ); END; PLS-00201: identifier must be declared thanks.
I have two tables one ordinary table and other is log of this table test_table test_tab_log I want to insert new row in the log table for each insert statement executed for basic table even if there is rollback executed. simply every row inserted in the base table ...
hello, Ii got an error when I want to use my directory created inside UTL_FILE.FOPEN invalid directory path within the procedure to open a certain file on my local machine.
