Stored Procedure
Jaya

Bangalore, India

#1 Aug 10, 2006
Hi All,

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.

Thanks,
Jaya

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Oracle Corporation Discussions

Title Updated Last By Comments
News Rimini Street Named to Inc. Magazine's List of ... (Aug '15) Aug '15 rajani 1
News A Rare Glimpse Inside The Life And Mind Of Orac... (Jan '15) Jan '15 Kid_Tomorrow 1
News SaaS and Cloud ERP Observations: Is Cloud ERP R... (Nov '13) Jun '14 Dimitar 2
News Oregon Governor Seeks Lawsuit Over Health Exchange (May '14) May '14 United Clowns 1
News Breaking (Bad?) Sap Hana Boss Vishal Sikka Resigns (May '14) May '14 Berblinger 1
News Oracle buys San Bruno-based Responsys for $1 bi... (Dec '13) Feb '14 Nature 4
News Enrollment in Obamacare very small in first day... (Nov '13) Nov '13 Space Cowboy 35
More from around the web