About: isa:264808291   Sponge Permalink

An Entity of Type : prov:Entity, within Data Space : wifo5-40.informatik.uni-mannheim.de:8890 associated with source dataset(s)

AttributesValues
rdf:type
prov:value
  • AnonymousJune 11, 2012 at 2:52 PMDECLARE l_sal emp.sal%TYPE; p_empno emp.empno%TYPE := 123; -- Invalid empno numberBEGIN SELECT NVL( ( SELECT sal FROM emp WHERE empno = p_empno ), 0 ) INTO l_sal FROM DUAL;END;/ReplyDeleteBellyJune 14, 2012 at 12:55 AMMartin,In my humble opinion you left out the most important one:Explicitly declare a cursor.All issues solved, except the fact that you must write a
prov:wasQuotedFrom
is prov:wasDerivedFrom of
Alternative Linked Data Views: ODE     Raw Data in: CXML | CSV | RDF ( N-Triples N3/Turtle JSON XML ) | OData ( Atom JSON ) | Microdata ( JSON HTML) | JSON-LD    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 07.20.3217, on Linux (x86_64-pc-linux-gnu), Standard Edition
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2012 OpenLink Software