Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Jai Shree Ram Oracle
  • Linux CPU info. Linux/Unix
  • pvmehta.com SQL scripts
    Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
  • crontab syntax Linux/Unix
  • create a folder in multiple places Linux/Unix
  • Standby Database Behavior when a Datafile is Resized on the Primary Database Note:123883.1 Oracle
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle
  • My Minimum Tuning Programs Oracle
  • EXTPROC Oracle
  • Looping for remote servers and find its database from oratab file. Linux/Unix
  • SQLPLUS COPY command Precautions. Oracle
  • Pending Distributed Transations Oracle
  • changing kernel parameter in Oracle Enterpise Linux Linux/Unix
  • V$transaction notes for finding XID composition. Oracle
  • ORA-3136 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

  • Running select from V$ views from remote server Linux/Unix
  • To find all disk io ( EMC as well as local) Linux/Unix
  • To see only files and/or folders using LS command Linux/Unix
  • chk_space_SID.ksh Linux/Unix
  • Changing default shell Linux/Unix
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix

Leave a Reply Cancel reply

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

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • avail.sh ( find filesystem spae usage) Linux/Unix
  • Read CSV File using Python Python/PySpark
  • pvmehta.com SQL scripts
    Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
  • How to change hostname in Linux Linux/Unix
  • Sending email with file attachment. Linux/Unix
  • DBMS_SQL for alter session. Oracle
  • Sample WW22 listener.ora Oracle
  • oradebug ipcrm ipcs Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme