ORACLE

Winscp is graphical user interface for doing various file operations, deployment, server configuration on Linux VM easily. Kindly follow below steps to connect to the Linux VM hosted in public cloud. In my case, I used Oracle Cloud VM for example. Details of the Cloud Infrastructure: VM : Oracle Linux […]

SFTP to Oracle Cloud Linux Instance

March 14, 2020 in Blog tagged Cloud / linux / ORACLE / sftp / winscp by vtm

Oracle EBS FND Tables

November 14, 2019 in Blog tagged ebs / ORACLE / table by vtm

sql — Every developer nowadays come up with problem of generating some random number or characters. There are some many in-build functions in popular programming languages. Out of which i am going to explain about ORACLE in build package DBMS_RANDOM. The DBMS_RANDOM package will generate random data in character, numeric or alphanumeric […]

Generating Random Characters in ORACLE 11G

August 19, 2016 in Blog tagged ORACLE / plsql / programming / random by vtm

Below are the enhancements in ORACLE 12C database datapump activities. NOLOGGING Option (DISABLE_ARCHIVE_LOGGING) The TRANSFORM parameter of impdp has been extended to include a DISABLE_ARCHIVE_LOGGING option. The default setting of “N” has no affect on logging behaviour. Using a value “Y” reduces the logging associated with tables and indexes during […]

Oracle 12c enhancements related to data pump

January 17, 2016 in Blog tagged 12c / database / datapump / ORACLE by vtm

Following are few bulit-in regular expression functions in ORACLE 11g Version. REGEXP_COUNT: REGEXP_COUNT returns the number of times a pattern occurs in a source string. The function evaluates strings using characters as defined by the input character set. It returns an integer indicating the number of occurrences of pattern. If no […]

Regular Expression functions in ORACLE 11G

August 17, 2015 in Blog tagged 11G / DB / ORACLE / REGULAREXPRESSION by vtm

A COMPLETE TECHNOLOGY BLOG!!