Posted in the Oracle Corporation Forum
#1 Aug 10, 2006
I am having a problem in writing a stored procedure.
I have a table called as model year which has two fields model year and model status. model year is the primary key column. If the user inputs a model year, the stored procedure should check whether the input is already present in the table or not, if yes it should update with the new input, else insert the new input.
Kindly help me to achieve the same.
Add your comments below
|Rimini Street Named to Inc. Magazine's List of ... (Aug '15)||Aug '15||rajani||1|
|A Rare Glimpse Inside The Life And Mind Of Orac... (Jan '15)||Jan '15||Kid_Tomorrow||1|
|SaaS and Cloud ERP Observations: Is Cloud ERP R... (Nov '13)||Jun '14||Dimitar||2|
|Oregon Governor Seeks Lawsuit Over Health Exchange (May '14)||May '14||United Clowns||1|
|Breaking (Bad?) Sap Hana Boss Vishal Sikka Resigns (May '14)||May '14||Berblinger||1|
|Oracle buys San Bruno-based Responsys for $1 bi... (Dec '13)||Feb '14||Nature||4|
|Enrollment in Obamacare very small in first day... (Nov '13)||Nov '13||Space Cowboy||35|
Find what you want!
Search Oracle Corporation Forum Now
Copyright © 2017 Topix LLC