Oracle, Java, Php, Javascript, Document Management System, Mybatis

1) In command prompt type netstat -a -o -n 2) find the PID number for that port number Proto Local Address Foreign Address ...

CREATE TABLE TEST( ID NUMBER PRIMARY KEY ); CREATE OR REPLACE PROCEDURE TEST_PROC IS BEGIN INSERT INTO TEST(ID) VALUES(5); FOR I IN 1..10...

Oracle Sql Select statement do not evaluate null values. Null values should be handled in the where condition of sql statements for all null...

Sql queries can be dynamic using Mybatis, may help reusing sql queries for more than one occasion. As per the context, Sql "where"...

In some cases it is necessary to get the set of data in the same procedure call. Sample example is demonstrated below. Employee class to hol...