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;   …

10 Reasons You’re Going to LOVE the History Feature in Oracle SQLcl

thatjeffsmith SQL Developer 3 Comments

I’m out on vacation this week, but you’re in luck. I have to do the Southwest 24 hour check-in thing, so that means I’m stuck on my laptop for a few minutes. If you’re a command-line kind of guy or gal, then you know all …

Related Posts Plugin for WordPress, Blogger...