End Date Responsibility from Oracle for List of Users

by Yogesh Pachpute
Posted on August 14, 2017August 14, 2017
Uncategorized

First create a temp table to hold user responsibilities to be inactivated. 1 2 3 4 CREATE TABLE xxcb_user_resp ( user_name VARCHAR2(240), resp_name VARCHAR2(240) ) Then insert record into temp tables, you may prepare these […]

by Yogesh Pachpute
Posted on February 23, 2017
Oracle Database

How to Alter Database Sequence or How to increment or decrements sequence. select * from all_sequences where sequence_name like ‘RA_TRX_NUMBER%’; SELECT last_number FROM all_sequences WHERE sequence_name = ‘RA_TRX_NUMBER_N1_81_S’; SELECT last_number FROM all_sequences WHERE sequence_name = […]

Blog at WordPress.com.