Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • ORA-01220 Oracle
  • UTL_FILE test program Oracle
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • Adding Datafile on Primary Server and Impact on Standby Server Oracle
  • Database logon trigger issue Oracle
  • Read CSV File using Python Python/PySpark
  • tuning commmand for cpu, ip and memory stats Linux/Unix
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • Good Link from metalink 1 Oracle
  • Jai Shree Ram Linux/Unix
  • DBMS_UTILITY.ANALYZE_SCHEMA Oracle
  • Jai Shree Ram Oracle
  • Wait time tuning research Oracle
  • Pending Transaction Neighbors Script Oracle
  • Monitor Long Running Job 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

  • rm_backup_arch_file.ksh Linux/Unix
  • switchlogfile.sh Linux/Unix
  • chk_space_SID.ksh Linux/Unix
  • nfs mount command Linux/Unix
  • avail.sh ( find filesystem spae usage) Linux/Unix
  • Important Solaris Commands 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_SQL for alter session. Oracle
  • Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
  • SQL Server Vs Oracle Architecture difference SQL Server
  • Finding last recovered file on DR and remove all chanracters before any “/” Linux/Unix
  • Temporary Tablespace Information and restriction. Oracle
  • SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • Find nth max and min. Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme