01427 Oracle Error

MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color Picker Languages C Language More ASCII Table Linux UNIX Java Clipart Techie Humor Advertisement ora 01427 during update Oracle Basics ALIASES AND AND & OR BETWEEN COMPARISON OPERATORS DELETE DISTINCT ora 01427 update statement EXISTS FROM GROUP BY HAVING IN INSERT INSERT ALL INTERSECT IS NOT NULL IS NULL JOIN LIKE MINUS NOT ora 01427 single row subquery update OR ORDER BY PIVOT REGEXP_LIKE SELECT SUBQUERY TRUNCATE UNION UNION ALL UPDATE WHERE Oracle Advanced Oracle Cursors Oracle Exception Handling Oracle Foreign Keys Oracle Loops/Conditionals Oracle Transactions Oracle Triggers String/Char

Sql Error Ora-01427 Single-row Subquery Returns More Than One Row

Functions Numeric/Math Functions Date/Time Functions Conversion Functions Analytic Functions Advanced Functions Oracle / PLSQL: ORA-01427 Learn the cause and how to resolve the ORA-01427 error message in Oracle. Description When you encounter an ORA-01427 error, the following error message will appear: ORA-01427: single-row subquery returns more than one row Cause You tried to execute a SQL statement that contained a SQL ora-01427 single-row subquery returns more than one row subquery that returns more than one row. Resolution The option(s) to resolve this Oracle error are: Option #1 Rewrite your query so that the subquery only returns one row. Option #2 Change your query to use one of the following with your subquery results: ANY ALL IN NOT IN For example, if you tried to execute the following SQL statement: SELECT * FROM orders WHERE supplier_id = (SELECT supplier_id FROM suppliers WHERE supplier_name = 'IBM'); And there was more than one record in the suppliers table with the supplier_name of IBM, you would receive the following message: The most common way to correct this SQL statement is to use the IN condition as follows: SELECT * FROM orders WHERE supplier_id IN (SELECT supplier_id FROM suppliers WHERE supplier_name = 'IBM'); Share this page: Advertisement Back to top Home | About Us | Contact Us | Testimonials | Donate While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy. We use advertisements to support this website and fund the development of new content. Copyright © 2003-2

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn single row subquery returns more than one row oracle more about Stack Overflow the company Business Learn more about hiring developers or posting

Oracle Sql Single-row Subquery Returns More Than One Row

ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community

Oracle Update Single-row Subquery Returns More Than One Row

Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up How to fix Ora-01427 single-row subquery returns more than one https://www.techonthenet.com/oracle/errors/ora01427.php row in select? up vote 4 down vote favorite When i execute the following query, i get the message like "Ora-01427 single-row subquery returns more than one row" SELECT E.I_EmpID AS EMPID, E.I_EMPCODE AS EMPCODE, E.I_EmpName AS EMPNAME, REPLACE(TO_CHAR(A.I_REQDATE, 'DD-Mon-YYYY'), ' ', '') AS FROMDATE, REPLACE(TO_CHAR(A.I_ENDDATE, 'DD-Mon-YYYY'), ' ', '') AS TODATE, TO_CHAR(NOD) AS NOD, DECODE(A.I_DURATION, 'FD', 'FullDay', 'FN', 'ForeNoon', 'AN', 'AfterNoon') AS DURATION, L.I_LeaveType AS LEAVETYPE, REPLACE(TO_CHAR((SELECT C.I_WORKDATE http://stackoverflow.com/questions/21397694/how-to-fix-ora-01427-single-row-subquery-returns-more-than-one-row-in-select FROM T_COMPENSATION C WHERE C.I_COMPENSATEDDATE = A.I_REQDATE AND C.I_EMPID = A.I_EMPID), 'DD-Mon-YYYY'), ' ', '') AS WORKDATE, A.I_REASON AS REASON, AP.I_REJECTREASON AS REJECTREASON FROM T_LEAVEAPPLY A INNER JOIN T_EMPLOYEE_MS E ON A.I_EMPID = E.I_EmpID AND UPPER(E.I_IsActive) = 'YES' AND A.I_STATUS = '1' INNER JOIN T_LeaveType_MS L ON A.I_LEAVETYPEID = L.I_LEAVETYPEID LEFT OUTER JOIN T_APPROVAL AP ON A.I_REQDATE = AP.I_REQDATE AND A.I_EMPID = AP.I_EMPID AND AP.I_APPROVALSTATUS = '1' WHERE E.I_EMPID <> '22' ORDER BY A.I_REQDATE DESC when i execute this without ORDER BY A.I_REQDATE DESC it returns 100 rows... sql oracle share|improve this question edited Jan 28 '14 at 5:44 asked Jan 28 '14 at 5:37 Sam1604 1,1502819 add a comment| 2 Answers 2 active oldest votes up vote 3 down vote accepted Use the following query: SELECT E.I_EmpID AS EMPID, E.I_EMPCODE AS EMPCODE, E.I_EmpName AS EMPNAME, REPLACE(TO_CHAR(A.I_REQDATE, 'DD-Mon-YYYY'), ' ', '') AS FROMDATE, REPLACE(TO_CHAR(A.I_ENDDATE, 'DD-Mon-YYYY'), ' ', '') AS TODATE, TO_CHAR(NOD) AS NOD, DECODE(A.I_DURATION, 'FD', 'FullDay', 'FN', 'ForeNoon', 'AN', 'AfterNoon') AS DURATION, L.I_LeaveType AS LEAVETYPE, REPLACE(TO_CHAR((SELECT max(C.I_WORKDATE) FROM T_COMPENSATION C WHERE C.I_COMPENSATEDDATE = A.I_REQDATE AND C.I_EMPID = A.I_EMPID), 'DD-Mon-YYYY'), ' ', '') AS WORKDATE, A.I_REASON AS REASON, AP.I_REJECTREASON AS REJECTREASON FROM T_LEAVEAPPLY A INNER JOIN T_EMPLOYEE_MS E ON A.I_EMPID = E.I_EmpID AND UP

CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. https://community.oracle.com/thread/1043243?start=15&tstart=0 Please enter a title. You can not post a blank message. Please http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/ora01427-singlerow-subquery-returns-more-than-one-row-4812873 type your message and try again. More discussions in PL/SQL and SQL All PlacesDatabaseDatabase Application DevelopmentPL/SQL and SQL This discussion is archived 1 2 Previous Next 21 Replies Latest reply on Feb 29, 2012 7:32 AM by 901702 Go to original post This content has been marked row subquery as final. Show 21 replies 15. Re: single-row subquery returns more than one row 759148 Mar 10, 2010 5:48 PM (in response to 759148) ORA-01427: single-row subquery returns more than one row help me i stuck.. please any suggest. if i can't update from sql. can you tell me how i can update multiple row maybe in pl/sql. Thanks subquery returns more Edited by: xoops on Mar 10, 2010 9:44 AM Like Show 0 Likes(0) Actions 16. Re: single-row subquery returns more than one row 6363 Mar 10, 2010 5:54 PM (in response to 759148) xoops wrote: ORA-01427: single-row subquery returns more than one row help me i stuck.. please any suggest. You could start by answering some of the multiple questions you have been asked and providing some of the information about your data that you have been asked for. Failing that one of these nice people would be perfectly willing to get on a plane and come and look at your data and fix your problem. http://www.google.com/search?q=oracle+consulting if i can't update from sql. can you tell me how i can update multiple row maybe in pl/sql. You have a logical problem. You cannot update a single value with multiple values. It doesn't matter whether you use SQL, PL/SQL or Cobol, you need to understand your data. Like Show 0 Likes(0) Actions 17. Re: single-row subquery returns more than one row 894071 Oct 12, 2011

Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon PCMag maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Richard Locutus DukeGanote Ramnath.Awate Dennis Stevenson Craig Borysowich Nikki Klein AbhaiTripathi bluesguyAZ59 iudithm knowscognosdoi Clinton Jones mircea_luca Iqbalyk COMPANIES VAI SendGrid Apperian Panaya Inc. View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. ORA-01427: Single-row Subquery Returns More Than One Row kool999 asked Jun 13, 2012 | Replies (20) I tried to execute this on oracle: update sn_voucher_d set payer_n = (select a.account_link_code_n from stg_lgsm_service_mast a, sn_voucher_d c where a.mobl_num_voice_v= c.subscriber_id) it gives me the following error ORA-01427: single-row subquery returns more than one row anyone can help? Join this group Best Answer Updated html error Use In instead of '=' or in the subquery use MAX-MIN Help the communi