Parameters and Binds for your RESTful Services

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

Your Favorite Oracle SQL Developer Trick, Animated.

thatjeffsmith SQL Developer 0 Comments

I had the privilege of spending a few days in Argentina and Brazil last week presenting on all things SQL Developer. It turns out, they enjoy the very same tricks that folks everywhere else do – especially the split editors and multiple tab groups. Here’s …

Related Posts Plugin for WordPress, Blogger...