Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by data78
-
Update command???
I think the problem is that the sub query returns all (multiple)rows that fit the condition a.ssn=b.ssn. The equal signs expects a single row to be returned. I thought to solve this you would use "IN" instaed of =.- data78
- Post #5
- Forum: Oracle: All versions
-
Update command???
I tried above, " single-row subquery returns more than one row." I replaced the equal sign with "in" and got "missing equal sign." :(- data78
- Post #3
- Forum: Oracle: All versions
-
Update command???
2 tables: Employee1 (emp_ssn, empl_name, dept_no) and Employee2 (empl_ssn,dept_no) The Employee1 table does not have data for dept_no. However Employee2 table does. How do I get dept_no data in Employee2 table over to Employee1 table? (you're updating multiple rows in Employee1 table.) < ERROR...- data78
- Thread
- Replies: 4
- Forum: Oracle: All versions
-
NT 4 Server Enterprise Edition
I can't find the serial number. It is an authentic CD, but I'm not sure if it is legal. I suppose to install it on the company server in a couple of days. Please help, if you know the serial number. Thanks in advance.- data78
- Thread
- Replies: 1
- Forum: Microsoft: Windows servers
