Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT) Oracle
  • Debugging Shell FIles Linux/Unix
  • OEM-Commnds Oracle
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • Clean up Oracle
  • move_arch_files.ksh Linux/Unix
  • initUOCIOTTO.ora Oracle
  • Find long Running Transaction Linux/Unix
  • How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
  • 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
  • How to calculate PROCESSES parameter Oracle
  • To seee semaphores and shared memory segments in Solaris Linux/Unix
  • Python class import from different folders Python/PySpark
  • get_vmstat.ksh for Solaris 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

  • good linux notes Linux/Unix
  • scp with ssh2 Linux/Unix
  • Validating ORACLE_SID againt oratab file. Linux/Unix
  • Generate SSH without password authentication. Linux/Unix
  • purge_trc.sh Linux/Unix
  • rm_backup_arch_file.ksh 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 (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • 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

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • TOP-N Sql to find Nth max or Top N rows Oracle
  • on IBM-AIX for display Linux/Unix
  • eplan9i.sql Oracle
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • mutex in Oracle 10.2.0.2 or Oracle 10g Oracle
  • JSON/XML Types in Oracle Oracle
  • find_string_in_database.sql Oracle
  • Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme