There are various logics to convert bigint data type to datetime. I use different logic based on each data extraction YYYYMMDDHRMISS - MA...
INFORMATION_SCHEMA is a quick way to get around a database. Hope this helps. Generate list of all table and columns in the table. Select * ...
If you are missing the network drives on an enterprise workstation, you can use the following commands to publish the drives shortcuts. n...
Recently had a custom requirement to auto populate PASSWORD column, while considering each password must be unique and self understood by ...
I was trying to search for ways to list all columns where special characters are entered. If some one can help in doing a lookup in a certa...
We can fetch sequence number using 3 commands: DBA_SEQUENCES all sequences that exist ALL_SEQUENCES all sequences that you have permi...
Recently i had to fetch the list of AD users where PasswordNeverExpires was selected. I used the following powershell script's to f...
Use the following script to verify an oracle user lock status. select username, account_status, created, lock_date, expiry_date from dba_u...
Recently came across the error on running crystal report. The report was developed some time in 2009, using an older version of oracle. T...
I was recently working on date manipulation in oracle DB. I came across different scenarios and had to go back to basics. Used the followi...