Skip to content

Instantly share code, notes, and snippets.

View DevYam's full-sized avatar
🎧

Divyam KS DevYam

🎧
View GitHub Profile
import java.sql.*;
public class OracleTableCopyUtility {
private static final String SOURCE_HOSTNAME = "source_hostname";
private static final String TARGET_HOSTNAME = "target_hostname";
private static final String SOURCE_SCHEMA = "source_schema";
private static final String TARGET_SCHEMA = "target_schema";
private static final String SOURCE_TABLE = "source_table";
private static final String TARGET_TABLE = "target_table";
private static final int NUM_ROWS_TO_COPY = 100;
@DevYam
DevYam / TableComparisionReport.java
Last active July 1, 2023 11:17
Add these dependencies - <dependencies> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>5.1.0</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>5.1.0</version> </dependency> </dependencies>
import java.sql.*;
import java.util.HashMap;
import java.util.Map;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.FileOutputStream;
import java.io.IOException;
public class CompareTables {
import java.sql.*;
import java.util.HashMap;
import java.util.Map;
public class CompareTables {
private static final String DB_URL = "jdbc:oracle:thin:@localhost:1521:xe";
private static final String USER = "username";
private static final String PASS = "password";
@DevYam
DevYam / Ex3.py
Created August 5, 2020 16:31
Guess The Number Game
# Guess the number Game
key = 43
count = 10
print("Total guesses left = ", count)
while True:
guess = input("Enter a number to guess\n")
if not guess.isnumeric():
print("Enter a valid number")
continue
// safely handles circular references
JSON.safeStringify = (obj, indent = 2) => {
let cache = [];
const retVal = JSON.stringify(
obj,
(key, value) =>
typeof value === "object" && value !== null
? cache.includes(value)
? undefined // Duplicate reference found, discard key
: cache.push(value) && value // Store value in our collection