UPDATE WITH A SELECT

CREATE TABLE TABLE_NAME
  (ID INT,NAME_01 VARCHAR2(100),NAME_02 VARCHAR2(1OO)
  )
INSERT INTO TABLE_NAME
  (ID,NAME_01,NAME_02
  )
SELECT 11,'A1','A2'
UNION ALL
SELECT 12,'B1','B2'
UNION ALL
SELECT 13.'C1','C2';

Comments

Drop Sequence and Create Sequence

Create a Sequence CREATE SEQUENCE SEQUENCE_NAME START WITH 22486 NOCACHE; GRANT SELECT ON SEQUENCE_NAME TO USER_NAME ; 2248 -Is a value which we want to start the sequence from Drop a Sequence DROP SEQUENCE SEQUENCE_NAME ;

Split String which has space and replace spaces with "/"

Sample String "ABCD123 ETS, NM" UPDATE TABLE_NAME SET COLUMN_NAME = SUBSTR( 'ABCD123 ETS, NM' , 0 , 4 ) || REPLACE ((SUBSTR(( REPLACE ( 'ABCD123 ETS, NM' , ', ' , '/' )), 5 ,INSTR(( REPLACE ( 'ABCD123 ETS, NM' , ', ' , ',/' )), ',' , 1 ) - 4 )), ' ' , '/' ) || REPLACE (SUBSTR( 'ABCD123 ETS, NM' ,INSTR( 'ABCD123 ETS, NM' , ',' , 1 ) + 2 ), 'NM' , 'NEW MEXICO' ) WHERE CONDITIONS;

Extracting Data in a Database Using Python

Extracting data in a database using python. Using Python to extract data in a MySQL table first we need to pip install pymysql Create table along with connection to the mysql server using python import pymysql connection=pymysql.connect(host='host',port=port,user='user',password='password',db='schema') #creating cursor cursor= connection.cursor() #query for create Table TABLES={} TABLES['employees'] = ( "CREATE TABLE employees (" "PersonID int," "LastName varchar(255)," "FirstName varchar(255)," "Address varchar(255)," "City varchar(255)" ")") for name, ddl in TABLES.items(): cursor.execute(ddl) connection.commit() connection.close() Insert Data into the MySQL Table using Python import pymysql # Data set to insert insert_people=[("8","Perera","L.D","123",...

Learn PL SQL, Data Science and Automation

Search This Blog