Help with Update Query -

Advertisement
November 30

I am trying to run the following update query:
update emp
set emp.COMM = 500
where emp.deptno = (select dept.deptno
from dept
where dept.loc = 'BOSTON'
or dept.loc ='NEW YORK')
SQL/Navigator returns:
ORA-01427 - Single Row Subquerty Returns More than one row.
How do I change the query so it will process with multiple return rows on the subquery?
The help text specified I used the ANY, ALL, IN, or NOT IN to specify which values to compare. Any body have an example of this?

Advertisement

Replay

Try this:
update emp
set emp.COMM = 500
where emp.deptno IN (select dept.deptno
from dept
where dept.loc = 'BOSTON'
or dept.loc ='NEW YORK')

View 2 Replies

Help with slooow query

November 30

I created a blogging tool for my students to use as I teach them internet safety and cyber citizenship. I am no CF master, but I dabble a little bit here and there. I need some help with this query. It is running extremely slow, which means I have pr

View All Replies

Please help with tricky query

November 30

I need help with SQL query (if it can be accomplished with query at all). I'm going to create a table with structure similar to: Article_Name varchar2(30), Author_Name varchar2(30), Position varchar2(2). Position field is basicly position of an artic

View All Replies

Hi guys can someone help with a query regarding the 'podcast app' why do they not have all the episodes that relate to one show available why only half or a selected amount

November 30

Hi guys can someone help with a query regarding the 'podcast app' why do they not have all the episodes that relate to one show available why only half or a selected amountTHanks...but some days they have all the episodes right back to the very first

View All Replies

I need help with a query

November 30

Hello everyone, First, some background information.  We have in place a table which records status changes on a work order.  The orders normally go through each status only once, however they do occasionally reuse status indicators.  For example, an

View All Replies

Need Help with INSTR Query

November 30

Hi, I have column which is having values like EMEA/MEA/IT EMEA/WE/GE EMEA/MEA/SA EMEA/WE/jk but i need to get all these rows based on some front selected values where we will select like EMEA/MEA & EMEA/WE.But that value will be ';' separated like EM

View All Replies

Help with my query

November 30

Hello all, Total newbie to this pl/sql stuff. So, deseperately need help in my query. BOOKING_ID     BOOKING_STATUS     BOOKING_DATE     BOOKING_TIME     BOOKING_DATE_TIME 1234567     CANCELLED     20090301     37252     5/1/2010 10:20 1234567     CA

View All Replies

Help with Updates

November 30

My son has a Droid Inc2 and has had multiple problems with updates. They always happen overnight and he gets a message telling him to do a battery pull to avoid further messages regarding the update. Each time we eventually have to do a hard reset so

View All Replies

Help with Update failure please

November 30

I have Adobe Photoshop CC running on win 7 64 bit. When doing the latest batch of updates one keeps failing with the error message "Adobe CSXS Infrastructure 4 Installation Failed Error Code U44M1P7" Can anyone help with this?Thanks Eshant I had

View All Replies

Help with update statement

November 30

Create table temp_sibs as (select 1701 sib_1, 1702 sib_2 from dual union all select 1171,1172 from dual union all select 1701,1172 from dual union all select 1171,1174 from dual union all select 1173,1176 from dual union all select 2001,2004 from dua

View All Replies

Need help with this query

November 30

Hi, I am using SQL Server 2008 Enterprise edition 64 bit on Windows serer 2008 enterprise edition 64 bit. The below query works fine. I am trying to rewrite the code without using the sub query. In the end i should get the same results for both the q

View All Replies

Help with building query

November 30

Hi ALl, Below is a code sample. My question is how to build the query in the for loop of public procedure to call all the private proedures (private_1,private_2,private_3 etc.) PACKAGE SAMPLE AS procedure public(start IN integer, end IN integer) END;

View All Replies

Need help with parameterizing query

November 30

Hello, Database Version: 11gR1 I have created a materialized view in my database which stores the moving average of Amount and Cummulative Amount for different customers for different months. The moving average window period is 6 months..i.e., If my

View All Replies

Please help with RecordSet Query

November 30

Hello all. I am trying to build a contact management system for different offices. Each person has a login they use to access their office's respective page. What I am wanting to do is pull up all the employees' information that work at the same loca

View All Replies

Help with image query and display

November 30

I want to show clients a few proofs. I've created a dropdown list of Projects. That calls a CFC query to search for the related image names within the DB. The images are stored locally/within my Flex Application File Folder Structure. After querying

View All Replies

Please help with some query

November 30

hello all! please, help me again. we have a foreign key discrepancy and my task is to create a view which will show the 3 aspects. Let's we have 3 schemas: A - good (which means that i will compare WITH A, source) B and C are bad (which mean that I w

View All Replies

Help with returning query from loadURL()

October 11

I finally came across loadURL() and figured out that I can use it to invoke my ColdFusion components without page reloading--very handy! Now, I need to figure out how to do this to return values from my components. Has anyone done this and have an ex

View All Replies

Need help with updates and new apple programs

November 30

something happened to my pc. having problems with my pc when it restarts. wondered if anyone whichapple updates require a restart, and which don't? if they require a restart to finish installation, they fail, and my pc crashes, and i have to resintal

View All Replies

Help with XPath Query

November 30

CREATE TABLE TEST_XML DOC_ID NUMBER(10), DOC_XML SYS.XMLTYPE Insert into TEST_XML (DOC_ID, DOC_XML) Values (1, XMLTYPE('<doc> <id>1</id> <store> <id>STR1</id> <dept> <id>DEPT1_STR1</id> <file_name&g

View All Replies

Help with updated new software version for 5800xp

November 30

hi, can any one help me with few question below. 1. what is the latest sofware version for nokia 5800. 2 How do you update it.because when i try to update it ask me to creat new server profile. whic i don't know how to creat. please help. many thanks

View All Replies

Tags:

  1. imovie program for a1151
  2. MacBook 5,4 windows
  3. новости челябинск мир 74
  4. surfaceqqq
  5. B8T1
  6. loosedgx
  7. studyingnwy
  8. becameyqh
  9. surprise6bi
  10. ibooks 3.1 ipa
Copyrights 2019 Fcffair BigData Resource, All rights reserved