Jae Mullikin
  • Male
  • United States
Share

Jae Mullikin's Discussions

ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE

Started this discussion. Last reply by Imran Amjad Nov 6, 2014. 6 Replies

 I'm a new programmer and am trying to include the following statement in my PLSQL code:select msa_code, mda_desc, zip_code_nk sales.msa where zip_code_nk = prod_rec.zip_code_nk;When there is not a…Continue

 

Jae Mullikin's Page

Gifts Received

Gift

Jae Mullikin has not received any gifts yet

Give Jae Mullikin a Gift

Latest Activity

Gwenda Brigmond liked Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
Nov 11, 2014
Imran Amjad replied to Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
"Well in my opinion the good idea is to use built-in NO_DATA_FOUND exception for this purpose, for example; BEGIN select msa_code, mda_desc, zip_code_nk from sales.msa where zip_code_nk = prod_rec.zip_code_nk; EXCEPTION when no_data_found then null;…"
Nov 6, 2014
Ruben Joyce liked Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
Sep 8, 2014
Nikita Flower liked Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
May 16, 2014
Elvina Thorn liked Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
May 13, 2014
Noel Arceneaux liked Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
Mar 12, 2014
Toney Villalobos liked Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
Feb 28, 2014
Kari Mennella replied to Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
"Thanks"
Feb 24, 2014
Kari Mennella liked Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
Feb 24, 2014
Wm Ector replied to Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
"Nice answer Valentine.. !!"
Feb 21, 2014
Marcellus Vandenburg liked Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
Feb 6, 2014
Mayra Ridinger liked Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
Jan 30, 2014
Odell Thornell liked Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
Jan 28, 2014
Collin Degennaro liked Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
Jan 21, 2014
Jennie Jonason liked Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
Jan 15, 2014
Corene Carr liked Jae Mullikin's discussion ORACLE/PLSQL: AVOID "DATA NOT FOUND" ERROR IN PLSQL CODE
Jan 13, 2014

Comment Wall

  • No comments yet!

You need to be a member of OracleConnections to add comments!

Join OracleConnections

 
 
 

© 2017   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service