- Data Integration
- All Products
SELECT Product_ID FROM Employees
ORA-0094: “Product_ID”: invalid identifier Database driver error... Function Name: Execute SQL Stmt: SELECT Product_ID from Employees Oracle Fatal Error
UPDATE, INSERT, DELETE only
One row for each statement with the NumRowsAffected for the statement.
One or more SELECT statements
Total number of database rows retrieved.
NumRowsAffected is zero in each row.
DDL queries such as CREATE, DROP, TRUNCATE
One row with zero NumRowsAffected.
DELETE from Employees WHERE Employee_ID = ‘101’; SELECT Employee_ID, LastName from Employees WHERE Employee_ID = ‘103’; INSERT into Employees (Employee_ID, LastName, Address)VALUES (‘102’, 'Gein', '38 Beach Rd')
Updated March 06, 2023