Question

Asked on 2006-02-22 at 09:18:02ID: 25487883

How to get ID for particular record

by: mosellv500

Rating7.8Very Good

I'm trying to update a single row in Oracle form. How can I get ID for this particular record? I have Oracle Editor button next to this record and complicated select statement in form procedure that selects all the records associated with this record from different tables. I need to update only one record, but if I use the update statement for Editor button it updates all selected records. Please HELP! Let me know if you have any questions

  1. Select Statement needed in Oracle
    Greeting, I have the following two tables in Oracle and need a select statment. TBL1 ------------------------------------------------------------------- ItemNum OrderNum Account Type 001 20001 111 C 001 20002 …
  2. Select statement in Oracle
    Greeting, I have the following records in an Oracle tbl. ItemNum Account 001 111 001 222 002 333 002 444 I need a select statement which gives me the following ouput. ItemNum Account1 Account2 001 111 222 002 333 …
  3. Oracle Function in a select statement?
    Hi I am wondering if there is any way to achieve the following I want to basically have a statement like this select x.col1, x.col2, myfunctionhere(symbol, parameter) from mytable x my function would accept a text string and a timestamp, do a select from another table based on the parameters like so myfunctionhere( accep…
  4. PL/SQL - Compare Fields in SELECT Statement
    For example... Select FIELD1, FIELD2, FIELD3, DOH, DOH1 From TESTDATA Where... In this case, for each record, field DOH is always populated with date (mm/dd/yyyy) data. Field DOH1 is populated (with date data) in some cases, but is blank or null in others. I want the select statement to check for an entry f…
  5. How can I UPDATE the particular rows returned f…
    I asked an earlier question and thought the answer worked, but it turns out it didn't. When I run the procedure below, and (for example) I send 1 as the MAXRECCOUNT, the cursor correctly returns one result, however the update statement (which basically updates the returned rows) is updating two rows. Is there a way to load the curs…

Solution

Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.

About this Solution
View This Solution - Start Your 30 Day Free Trial
Zone
General
Tags
get oracle record how id
Participating Experts
3
Solution Grade
A

Replies

 by:

Posted on 2006-02-24 at 02:37:45ID: 28397156

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: Venabili

Posted on 2006-03-20 at 14:31:01ID: 28397157

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: CetusMOD

Posted on 2006-03-25 at 02:20:11ID: 28397158

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Stay Connected

Oracle Around the Web

The latest Oracle news, tips, and tricks

Oracle Unveils Netra SPARC T3 Servers

New Carrier-Grade Blade and Rackmount Servers Deliver Better Performance, Density and Power Efficiency for the Communications Industry ...

read more

Oracle fixes 21 flaws in Java SE, Java for Business

Oracle is fixing 21 flaws in its Java SE and Java for Business products in its February critical patch update issued this week ...

read more

Obama’s Silicon Valley “Tech Supper”

Why was he there? Who wasn’t invited and why? What did they talk about? Why was he really there? These are the questions being debated ...

read more

Featured Oracle Experts

slightwv

slightwv has answered more than 2,000 Oracle questions and oversees database management within the U.S. Government. Slightwv

sdstuber

A regular presenter at the Collaborate conference, Oracle developer sdstuber is a top expert in PL/SQL and Oracle 9, 10 and 11. sdstuber

Testimonials

What users are saying about our experts

"The Oracle gurus provide answers, solutions and valuable workarounds"

User: schwertner

"Wow! Excellent, valuable explanation. Hats off to you"

User: aseshu70

"Solution worked fantastic and performs excellent! Thanks heaps"

User: klausbrandlhuber

Top Experts

  1. slightwv

    2,000

    0 points yesterday

    Profile

BrowseBecome an Expert