Top "Ora-01427" questions

ORA-01427: single-row subquery returns more than one row

UpdateError: Receiving Error ORA - 01427 Single-row subquery returns more than one row

I am trying to update a column based on another column in the same table (student table) and a column …

Read More
sql oracle sql-update ora-01427
How to UPDATE one column using another column in another table? SQL Error: ORA-00933: SQL command not properly ended

I have tried everything I can think of but couldn't solve this SQL error: SQL Error: ORA-00933: SQL command not …

Read More
sql oracle ora-01427
Update multiple rows in oracle

Can you tell me how to update multiple rows in oracle as when I fired the update statement it gave …

Read More
sql oracle ora-01427
Erroneous ORA-01427: single-row subquery returns more than one row

I'm getting the error [ORA-01427: single-row subquery returns more than one row] when I execute a query. I have a …

Read More
sql oracle ora-01427
Subquery returning multiple rows during update

I have two tables T_SUBJECTS (subject_id, date_of_birth) and T_ADMISSIONS (visit_id, subject_id, date_of_…

Read More
oracle correlated-subquery ora-01427
Left Outer Join with subqueries?

---------- User ---------- user_ID(pk) UserEmail ---------- Project_Account ---------- actno actname projno projname ProjEmpID ProjEmpMGRID Where ProjEmpID,ProjEmpMGRID …

Read More
sql oracle plsql ora-01427