473,692 Members | 2,454 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Error: ORA-01427:single-row subquery returns more than 1 row?

1 New Member
QUERY->
Expand|Select|Wrap|Line Numbers
  1.  select *
  2.   from sttb_record_log
  3.  where table_name IN ('STTMS_CUSTOMER', 'STTM_CUSTOMER')
  4.    AND KEY_ID LIKE(SELECT '%' || CUSTOMER_NO || '%'
  5.                       FROM STTM_CUSTOMER
  6.                     )
Error-ora-01427:single-row subquery returns more than one row
Aug 2 '12 #1
1 3429
Rabbit
12,516 Recognized Expert Moderator MVP
Please use code tags when posting code.

When using the like operator with a subquery, the subquery must only return one row.
Aug 2 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1934
by: Dalan | last post by:
I'm not certain if this is doable in the manner explained below, but I'm certain that there have been Access developers who have done something similar. So whatever insight and assistance that can be provided will be much appreciated. There is a separate Update Query (well several) that consolidate various goods from separate tables for access and selection on a sales/order invoice form. The data which is available is the TagNo,...
6
5993
by: GJW | last post by:
Does anybody know a simply way I can run a query on a single table and merge the results of several columns of data into a single column of data? IE Table1: First Name Second Name ------------ ----------------
8
5061
by: Thomas R. Hummel | last post by:
Hello, I am currently working with a data mart. The business wants a view of the data that shows columns from the main table along with up to 6 codes from a related table (not related by the full PK of the main table though). They don't care about the order of the codes or how they are assigned to their columns. Here is an example, which will hopefully make this clearer: CREATE TABLE dbo.Main_Table (
1
8824
by: bassamsuha | last post by:
Hi, I have two tables many to many relationship between them, and i've created third one that to have both IDs. my problem is that I want to update both of them in the same time. I do not know how to build and access my updating query from my single form. I have done my select query and it worked fine, but my problem is that i do not know how to update and add new records.?? Any help pls??
27
2729
by: spminba | last post by:
First, I want to say I have used this board to resolve many issues that I have had with access and I thank everyone who contributes. I have attempted to resolve my issue myself, but I am stumped and would appreciate any help you can give. This is a database to make reservations I am trying to run a query against two tables. The first table (families) has the following fields Family Neighborhood Street nmbsnglebedsavail
0
1812
by: RobinDiederen | last post by:
Suppose I write a SQL query, giving a single point result (for instance, SELECT COUNT(*) FROM persons). After doing the query, I want a assign it's result to a variable with the identical type. How do I do that? For example: SQL = "SELECT COUNT(*) FROM persons" Set Db = CurrentDb Set rst = Db.OpenRecordset(SQL, dbOpenDynaset) So, rst holds the result, which has to be an integer. Just... how can I use rst of the RecordSet type in...
1
1306
by: sachin shah | last post by:
hi my table having record cust_name sachin's vishal's sumeet rajesh
0
2447
crystal2005
by: crystal2005 | last post by:
Hi, I am having trouble with some complex SQL queries. I’ve got winestore database, taken from Web Database Application with PHP and MySQL book. And some question about queries as the following 1. The wine name, grape variety, year, winery, and region 2. The minimum cost of wine in the inventory 3. The number of bottles available at the minimum price 4. The total number of bottles available at any price 5. The total number of unique...
3
5070
by: samour | last post by:
hello every body how can i get red of this error : "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near" when i insert a new category in database i get this error since category name include single quotation mark. example of Category name not accepted : un’ mecca C;f : SELECT IdCategoria FROM categoria WHERE categoria.title='Familly’Ceka'
1
3025
by: mintz87 | last post by:
i'm really rusty in the PL/SQL (spent last 5 yrs in SQL Server) I'm wanting to have a PL/SQL procedure build SQL queries when called. here is what i have so far: declare a_sel varchar2(255) := 'select * from VISIT_VIEW where'; begin dbms_output.put_line ('select * from VISIT_VIEW where ');
0
8543
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8964
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8806
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8808
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6460
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5820
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4558
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2975
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2241
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.