Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
CREATE OR REPLACE PACKAGE BODY IFSAPP.hert_column_sort IS FUNCTION col(text_in IN VARCHAR2, number_in IN NUMBER) RETURN NUMBER IS tempval NUMBER; number_in_ NUMBER; text_in_ VARCHAR2(400); BEGIN number_in_ := number_in; text_in_ := text_in; IF number_in_ <=0 THEN tempval := 0; ELSIF number_in_ = 1 THEN tempval := to_number(substr(text_in_,1,instr(text_in_,';')-1)); ELSE tempval := to_number(substr(text_in_,instr(text_in_,';',1,number_in_-1)+1,instr(text_in_,';',1,number_in_)-1-instr(text_in_,';',1,number_in_-1) )); END IF; RETURN tempval; END; END hert_column_sort;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Assistance required for troubleshooting an issue - ORA-12154: TNS error - MS SQL Server 2008||3||68|
|having some issue on pl sql procedure||1||41|
|sql server store procedure contains temp tables need to convert oracle?||3||51|
|Need help figuring out which database the Oracle connection string is accessing?||13||36|
Join the community of 500,000 technology professionals and ask your questions.