Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

UPDATE MULTIPLE TABLES IN A SINGLE QUERY

825873May 16 2011 — edited May 16 2011
Is it possible to update multible tables in a single query using join queries.

Comments

clcarter
Which version of pl/sql developer? Have you tried the sql developer http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
I'm adverse to doing this
Why? If a program has difficulties with an install location either uninstall and don't use it, or move it.

ORA-12514 is a client problem. It's saying it has no idea how to connect with what you're asking for.
orafad
A known workaround is to uninstall the program/tool (.e.g Toad) and re-install using a path without brackets.

If you don't want that, you could install a current (11.2) Oracle Client package and have the tool use that instead of client libs included in XE server install, as long as it supports the Oracle version in question. A current version of whatever tool you are using should be compatible with current Oracle versions, but you would need to verify with each maker's support site (e.g. requirements, compatibility matrix or similar).

For ease of install etc., take a look at Instant Client.
http://www.oracle.com/technetwork/database/features/instant-client/index-100365.html

Edited by: orafad on Apr 14, 2012 6:50 PM
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 13 2011
Added on May 16 2011
#multiple, #update
3 comments
78,804 views