How can i save dual table data into a table by Interactive Grid?
Example:
SELECT NULL AS DEPARTMENT_ID,NULL AS DEPARTMENT_NAME FROM DUAL
I Want to insert it in Department Table.
Select department_id,department_name from department.
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine 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.
How can i save dual table data into a table by Interactive Grid?
Example:
SELECT NULL AS DEPARTMENT_ID,NULL AS DEPARTMENT_NAME FROM DUAL
I Want to insert it in Department Table.
Select department_id,department_name from department.
Error: ORA-01732: data manipulation operation not legal on this view
PROCESS- INTERACTIVE GRIDE AUTOMATIC ROW PROCESSING(DML)
TARGET TYPE- PL/SQL CODE
BEGIN
CASE :APEX$ROW_STATUS
WHEN ‘C’ THEN
INSERT INTO Department
(department_id,department_name)
VALUES
(:DEPARTMENT_ID,:DEPARTMENT_NAME)
END CASE;
END;
BEGIN
CASE :APEX$ROW_STATUS
WHEN ‘C’ THEN
INSERT INTO Departments
(department_id,department_name)
VALUES
(DEPARTMENTS_SEQ.nextval,:DEPARTMENT_NAME);
END CASE;
END;
ORA-06592: CASE not found while executing CASE statement
Case syntax is not correct, it should be as follows CASE WHEN :APEX$ROW_STATUS = ‘C’ THEN. You can use IF instead of CASE: