Dynamic Artifact Id Name in Maven

In this tutorial, i will give you an example how to create Artifact Id dynamically using maven. below my pom.xml: <groupId>sample-project</groupId> <artifactId>sampleproject–${your_parameter}</artifactId> <version>0.1.0</version><groupId>sample-project</groupId> <artifactId>sampleproject–${your_parameter}</artifactId>

Read More

Alter Table Column To Primary Key Or Identity (Oracle)

ALTER TABLE YOUR_TABLE_NAME ADD CONSTRAINT PK_CONSTRAINT_NAME PRIMARY KEY (YOUR_COLUMN_NAME);ALTER TABLE YOUR_TABLE_NAME ADD CONSTRAINT PK_CONSTRAINT_NAME PRIMARY KEY (YOUR_COLUMN_NAME); ALTER TABLE YOUR_TABLE_NAME ADD ( YOUR_COLUMN_NAME INT

Read More

How To Include All Dependencies Jar into Main Jar Maven

My pom.xml : <build> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-dependency-plugin</artifactId> <executions> <execution> <id>copy-dependencies</id> <phase>prepare-package</phase> <goals> <goal>copy-dependencies</goal> </goals> <configuration> <outputDirectory>${project.build.directory}/classes/lib</outputDirectory> <overWriteReleases>false</overWriteReleases> <overWriteSnapshots>false</overWriteSnapshots> <overWriteIfNewer>true</overWriteIfNewer> </configuration> </execution> </executions> </plugin>

Read More

My Oracle Experience Part 1

I want to share to you my exploration in ORACLE database: ROWTYPE variable ALIAS in ORACLE >> SELECT COLUMN_NAME “COLUMN ALIAS” FROM TABLE LOOP

Read More

Sample Dynamic Query in ORACLE Procedure

CREATE OR REPLACE PROCEDURE USPS_GET_DYNAMIC_QUERY ( RESULTSET OUT SYS_REFCURSOR ) AS v_strSql VARCHAR(4000); BEGIN v_strSql := ‘SELECT * FROM TBLM_DATA’; OPEN RESULTSET FOR v_strSql;

Read More