In this article, we will be discussing the use cases of the tr Unix command with examples. tr command tr is used to Translate characters. Syntaxtr [-c] [-d] [-s] [string1] [string2] -c Complement the set of characters specified by string1. -d Delete all occurrences of input characters that are specified by string1. -s Replace instances of …
tr command in Unix Read More »
Here in this post,I am decoding all the facts about Guest User password in 11i/R12 What is Guest User Password Guest user password is very important for the functioning of Application SSWA. Self service login used this password to verify the user password. Self service will not come upif this password is incorrect.Direct form login will …
What is Parallel Execution in Oracle database Parallel execution in oracle allows a single SQL statement to be executed by a multiple processes executing concurrently on different CPU’s. It increases throughput by utilizing more resources (Memory, CPU & I/O).It uses a pool of instance background processes (query slaves) .Based on Parallel Execution you are able …
Many times we get confused with Logical I/O and Physical I/O in Oracle Database. Logical I/O and Physical I/O is called Logical reads and Physical reads respectively I am trying to clear all the doubt about what is Logical read in oracle and Physical I/O in Oracle Database What is Logical I/O (LIO) in Oracle It is …
What is Logical I/O (read) and Physical I/O(read) in Oracle Database Read More »
SubQueries in Oracle (1) A Subquery or Nested query is a query within another SQL query and embedded within the WHERE clause. A subquery is a query within a query (2) A subquery is used to return data that will be used in the main query as a condition to further restrict the data to …
We can move file or directory from one location to another location in Linux using mv command . This command can also be used to rename the file or directory also.This is a quite a useful command. mv – move files(s) /dirs Options: – -f mv will move the file(s) without prompting even if it …
How to move a file/directory in Linux with Example Read More »
