Select count of all tables

tabcount.sql

#!/bin/bash

# Check if directory path is provided as an argument
if [ $# -ne 1 ]; then
    echo "Usage: $0 <directory_path>"
    exit 1
fi

directory="$1"

# Check if the directory exists
if [ ! -d "$directory" ]; then
    echo "Directory $directory does not exist."
    exit 1
fi

# Search for .pks files in the directory
for file in "$directory"/*.pks; do
    # Extract package name from the file and trim whitespace
    package_name=$(grep -oiE 'create\s+(or\s+replace\s+)?package' "$file" | awk '{print $2}' | awk '{$1=$1};1' | tr '[:upper:]' '[:lower:]')
    # Extract file name without extension and convert to lowercase
    file_name=$(basename "$file" .pks | tr '[:upper:]' '[:lower:]')

    # Check if package name is not equal to file name
    if [ "$package_name" != "$file_name" ]; then
        echo "File: $file"
        echo "Package name: $package_name"
        echo "File name   : $file_name"
        echo "Package name is not equal to file name"
        echo "------------------------"
    fi
done