Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Implementing Listener Security Oracle
  • How to Modify the statistics collection by MMON for AWR repository Oracle
  • Drop database in Oracle 10g Oracle
  • Oracle Data Direct to TAPE Oracle
  • Complete Git Tutorial for Beginners GIT
  • Oracle Recommended Patches — Oracle Database ID 756671.1 Oracle
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle
  • ORA-3136 Oracle
  • Checking SQL Server Version SQL Server
  • Running some SQL on multiple databases connecting using monitoring userid and password Linux/Unix
  • Useful Solaris Commands on 28-SEP-2005 Linux/Unix
  • Goog notes on X$ tables Oracle
  • Find Plan Hash value fphv.sql Oracle
  • Export With Query Another Example. Oracle
  • Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql 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

  • crontab syntax Linux/Unix
  • Korn Shell Arithmatic Linux/Unix
  • How does one overcome the Unix 2 Gig file limit? Linux/Unix
  • chk_space_SID.ksh Linux/Unix
  • Running select from V$ views from remote server Linux/Unix
  • oracle_env_10g_CADEV 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)
  • Django (0)
  • GIT (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (395)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (343)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • prepfiles.sh for step by step generating pending statistics files10-Mar-2026
  • tracksqltime.sql05-Mar-2026
  • Complete Git Tutorial for Beginners25-Dec-2025
  • Postgres DB user and OS user.25-Dec-2025
  • 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

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • eplan.sql Oracle
  • OEM-troubleshooting on 20-MAY-08 Oracle
  • Renaming Global Name GLOBAL_NAME Oracle
  • dbinv.sql Oracle
  • Privilege to describe the table. Oracle
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • When to rebuld B-tree index Oracle
  • Backup and Recovery Scenarios Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme