Create view with table from different schema in Oracle

GRANT ALL ON VOYA_LNDG.LNDG_NEWLBDOBDECEASED_12012017 TO OIDFATM WITH GRANT OPTION;

Query to Change DB Names in SQL Server

USE [master]; GO ALTER DATABASE DBAdmin SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO EXEC sp_renamedb N’DBAdmin’, N’DBAdmin_OLD’; GO COMMIT — Add users ALTER DATABASE [DBAdmin_OLD] SET MULTI_USER GO

How to eliminate New line and Carriage Return in oracle

The Column B in the table A has data like the following. ‘”0.00000 “‘   This is eliminated when the run the below query. UPDATE A SET UT_CUMWD = TRIM( REPLACE( TRIM( TRANSLATE( TRANSLATE( TRANSLATE(B, CHR(10), ‘ ‘) , CHR(13), ‘ ‘) , CHR(09), ‘ ‘) ), ‘”‘,”) ) ; Commit;    

First blog post

This is the excerpt for your very first post.