My Oracle Procedure : CREATE OR REPLACE PROCEDURE USPS_GET_DATA (PRC OUT SYS_REFCURSOR) AS BEGIN OPEN PRC FOR SELECT * FROM TBLM_DATA; END;create or replace
Read More
How To Connect JAVA To MongoDB
In this tutorial, I want to share my experience in connecting JAVA to MongoDB. My maven dependencies: <dependency> <groupId>org.mongodb</groupId> <artifactId>mongodb-driver</artifactId> <version>3.9.0</version> </dependency> <dependency> <groupId>org.mongodb</groupId>
Read More
JAVA Web Crawler Using Jsoup
In this tutorial, I want to share my learning experience about web crawler using jsoup framework. For the beginning, I write a simple code
Read MoreSample Encrypt & Decrypt String in Java
In this tutorial, i will give a simple example how i encrypt & decrypt string with JAVA. Below my code: import java.util.Base64; import javax.crypto.Cipher;
Read MoreBasic ASP C#
I hope this first tutorial can help you to answer below question: How to load AspxGridView How to read Web.Config file How to get
Read MoreGet Prev & Next Row Values in SQL Server with LEAD & LAG Clause
In this tutorial, i want to share how to get prev or next row value with LAG & LEAD clause in SQL Server. I
Read MoreAllowing Static Resources Access of Spring Security
Actually, Spring boot will give an access to static resources (Css, Js, etc.) by default. But, Spring Security will deny all request so the
Read MoreJAVA XML Validator
In this tutorial, i will give you an example how to validate xml file based on xsd in JAVA. Below code will validate and
Read MoreConcatenate Multiple row String into One Row
i found this useful script while finishing one of my work. XML Path is one of SQL Server clause that will help you to
Read MorePandas DataFrame
i hope this post will be helpful for all beginner of python, especially to pandas user. i use winpython as the environment. sample_data.csv COL1
Read More