User Profile

Collapse

Profile Sidebar

Collapse
mohan705
mohan705
Last Activity: Oct 20 '08, 02:37 PM
Joined: Sep 20 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mohan705
    replied to perl help
    in Perl
    Hi

    I want to search for columns start_dt and end_dt in all my tables ,wrote shell sript to find the list of tables .I am new to perl want to do it same in perl.Any help it would be appericiated.

    Code:
    for name in `cat list.txt`
do 
tabname=`awk  /CREATE TABLE /{table=$2; start=0; }
 /START_DT/ { start++ }
 /END_DT/ && start  { print table }'  "$name.sql"`
echo
    ...
    See more | Go to post
    Last edited by eWish; Sep 20 '08, 02:39 PM. Reason: Fixed code tags

      Leave a comment:

    • mohan705
      started a topic perl help
      in Perl

      perl help

      Hi
      I want to search for columns start_dt and end_dt in all my tables ,wrote shell sript to find the list of tables .I am new to perl want to do it same in perl.Any help it would be appericiated

      [code=perl]
      for name in `cat list.txt`
      do
      tabname=`awk /CREATE TABLE /{table=$2; start=0; }
      /START_DT/ { start++ }
      /END_DT/ && start { print table }' "$name.sql" `
      echo...
      See more | Go to post
      Last edited by eWish; Sep 20 '08, 02:40 PM. Reason: Added code tags
      No activity results to display
      Show More
      Working...