Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • ORA-4031 issue and solution on 09-MAY-2008 Oracle
  • Adding a new disk and mount it automatically. on VMWARE LINUX Linux/Unix
  • Explain Plan Output 2 Oracle
  • chk_space_SID.ksh Linux/Unix
  • Checking SQL Server Version SQL Server
  • Mutating Table Error while using database trigger Oracle
  • Changing Instance Name ( No DB_NAME) Oracle
  • Oracle Standby Database Library Index from Metalink Oracle
  • How does one SELECT a value from a table into a Unix variable? From SQL to Shell Linux/Unix
  • How to know Number of CPUs on Sun Box Linux/Unix
  • Adding or Dropping Online Redo Log Files When Physical Standby in place Oracle
  • Small sample shell program Linux/Unix
  • SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle
  • Implementing Listener Security Oracle
  • Does DBMS_JOB recompute the NEXT_DATE interval after or before Oracle

Search and Replace vi editor command.

Posted on 29-Jul-2005 By Admin No Comments on Search and Replace vi editor command.

Changing Case

To change all the lower case characters to UPPER case characters, starting from the current line, and going for 5 lines, type

:s/^.*$/U&/5

To change from UPPER to lower, type

:s/^.*$/L&/5

Deleting characters

To delete the first 5 characters off of every line in the current file, type

:%s/^…..//g

Linux/Unix, shell

Post navigation

Previous Post: newupload.html
Next Post: For Search and replace unix command.

Related Posts

  • check_copy_progress.sh Linux/Unix
  • Single character replacement in Unix Linux/Unix
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • set_env_dba Linux/Unix
  • Changing default shell Linux/Unix
  • Validating ORACLE_SID againt oratab file. Linux/Unix

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (342)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • DBMS_UTILITY PACKAGE Oracle
  • sess1.sql Oracle
  • arch_configUOCIOTTO.ora Oracle
  • SQL Server: How to see current transactions or requests SQL Server
  • Index Range Scan Oracle
  • tblwopk.sql /* Find Tables Without PK */ Oracle
  • Remove DOS CR/LFs (^M) Linux/Unix
  • pvm_pre_change.sql Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme