Parameters and Binds for your RESTful Services

thatjeffsmith Database Stuff 0 Comments

I have a very simple, and not very elegant stored procedure. CREATE OR REPLACE PROCEDURE ADD_EMP ( P_EMP_NAME IN SIMPLE_EMP.name%TYPE, P_EMP_SALARY IN SIMPLE_EMP.SALARY%TYPE, P_OUT_ID OUT SIMPLE_EMP.id%TYPE, P_OUT_TOTAL OUT INTEGER ) AS BEGIN INSERT INTO SIMPLE_EMP (name, SALARY) VALUES (P_EMP_NAME, P_EMP_SALARY) RETURN id INTO P_OUT_ID;   …

Formatting vs Changing Code as You Type

thatjeffsmith SQL Developer 13 Comments

Reviewing my timeline, I came across this gem from Franc. I hate seeing SQL with keywords in uppercase and identifiers in lowercase. identifiers are case sensitive. Not keywords. — Franck Pachot (@FranckPachot) February 7, 2017 Franck isn’t alone – a lot of people hate it …

Related Posts Plugin for WordPress, Blogger...