Skip to content

Instantly share code, notes, and snippets.

View shadabshaukat's full-sized avatar
🕶️

Shadab Mohammad shadabshaukat

🕶️
15 followers · 12 following
View GitHub Profile
@shadabshaukat
shadabshaukat / OCI_Single_Deploy.html
Last active February 10, 2021 23:25
OCI_Single_Deploy
<html><a href="https://cloud.oracle.com/resourcemanager/stacks/create?zipUrl=https://github.com/shadabshaukat/OCI_DBMigrationTools_Image/ZDM-Migrate-v3-18Dec2020.zip" target="_blank">
<img src="https://oci-resourcemanager-plugin.plugins.oci.oraclecloud.com/latest/deploy-to-oracle-cloud.svg" alt="Deploy to Oracle Cloud"/>
</a>
</html>
@shadabshaukat
shadabshaukat / main.tf
Last active April 3, 2021 02:40
main.tf
terraform {
required_version = ">= 0.12.0"
}
provider "oci" {
@shadabshaukat
shadabshaukat / variable.tf
Created February 11, 2021 06:29
variable.tf
variable "tenancy_ocid" {}
variable "region" {}
variable "compartment_ocid" {}
variable "subnet_ocid" {}
variable "ssh_public_key" {}
@shadabshaukat
shadabshaukat / sql
Created March 10, 2021 23:08
sql
sql /nolog
set cloudconfig /home/opc/client/oracle/19.3.0/wallet/Wallet_PAYGDEV.zip
show tns
connect admin/********@paygdev_high
@shadabshaukat
shadabshaukat / table.sql
Created March 10, 2021 23:10
Table
create table big_table
as
select rownum id,
OWNER, OBJECT_NAME, SUBOBJECT_NAME,
OBJECT_ID, DATA_OBJECT_ID,
OBJECT_TYPE, CREATED, LAST_DDL_TIME,
TIMESTAMP, STATUS, TEMPORARY,
GENERATED, SECONDARY
from all_objects a
where 1=0
@shadabshaukat
shadabshaukat / vlock_plsql.sql
Created March 10, 2021 23:12
block plsql
declare
l_cnt number;
l_rows number := &1;
begin
insert /*+ append */
into big_table
select rownum,
OWNER, OBJECT_NAME, SUBOBJECT_NAME,
OBJECT_ID, DATA_OBJECT_ID,
OBJECT_TYPE, CREATED, LAST_DDL_TIME,
@shadabshaukat
shadabshaukat / StreamTweetsOracleUpdateStatus.py
Last active April 11, 2021 04:16
Stream Tweets Oracle Cloud Infrastructure Py2
## Python2.7 ##
import sys
import json
import tweepy
import cx_Oracle
import datetime
from tweepy import Stream
from tweepy import OAuthHandler
from tweepy.streaming import StreamListener
from datetime import datetime
@shadabshaukat
shadabshaukat / tweets.py
Last active April 4, 2021 01:45
SQL Code for Tweets OCI Sentiment Analysis
CREATE TABLE "ADMIN"."TWEET_LIVE_STREAM"
( "ID" NUMBER,
"USERNAME" VARCHAR2(500 BYTE),
"TIMEWHYUPUNISHME" TIMESTAMP (6) DEFAULT systimestamp,
"TWEET_JSON" CLOB,
@shadabshaukat
shadabshaukat / tweetsqlquery.sql
Created April 4, 2021 01:54
SQL Queries Tweet
-- SQL Queries --
select tweet from V_LIVE_TWITTER_FEED;
select count(*) from V_LIVE_TWITTER_FEED;
select * from TWEET_LIVE_STREAM;
@shadabshaukat
shadabshaukat / OCIS3.py
Last active May 6, 2021 03:16
OCI S3 Compatible API
import boto3
s3 = boto3.resource(
 's3',
 region_name="ap-sydney-1",
 aws_secret_access_key="**************",
 aws_access_key_id="****************************************",
 endpoint_url="https://ocicpm.compat.objectstorage.ap-sydney-1.oraclecloud.com"
)