The procedure below helps in order to find a specific value in the tables declared at TABLES_SET cursor: CREATE procedure OLTP_SIA.find_specific_value (theString IN VARCHAR2) is match_count INTEGER; the_table VARCHAR2(150); CURSOR…
The procedure below helps to find which record has text instead of number, so it produces "ORA-01722: invalid number" when you try to join with another number field. DECLAREEMPLID VARCHAR2(15);LAST_EMPLID…
The code below sends e-mail when someone visits your site (except yourself, assuming that you are testing locally): if(!empty($_REQUEST)){ $theRemoteAddr = $_SERVER['REMOTE_ADDR']; $theRemoteHost = gethostbyaddr($_SERVER['REMOTE_ADDR']); //send mail: $receiver="myself@mymail.com"; $from="info@swkb.net"; $subject="someone…