Blog

CommandLine Mail Sender: Top Tools and Example Commands

Sending email from the command line is useful for automation, monitoring alerts, scripts, and quick one-off messages without opening an email client. This guide covers reliable CLI tools, installation notes, authentication and security tips, and practical example commands for Linux/macOS (Windows examples use WSL or native ports).

When to use a CLI mail sender

• Automation: cron jobs, CI pipelines, backups, and monitoring alerts.
• Scripting: include email notifications inside shell scripts or programs.
• Minimal environments: servers or containers without GUI mail clients.

Key considerations

• Authentication: Most SMTP servers require username/password or OAuth.
• Encryption: Use TLS/STARTTLS to protect credentials and content in transit.
• Deliverability: Use proper From, Reply-To, and SPF/DKIM/DMARC on sending domains to avoid spam.
• Dependencies: Some tools rely on system MTA (sendmail/postfix) or external services.

Top tools

1) mailx (Heirloom mailx / BSD mailx)

• Description: Traditional Unix mail client with scripting-friendly interface.
• Install: apt: sudo apt install heirloom-mailx or macOS: brew install mailx.
• Strengths: Widely available, supports SMTP auth and TLS.
• Limitations: Different distro variants have slightly different flags.

Example (SMTP with TLS and auth):

Code
Copy CodeCopied
echo “Body text” | mailx -v  -s “Subject here”   -S smtp=“smtp://smtp.example.com:587”   -S smtp-use-starttls   -S smtp-auth=login   -S smtp-auth-user=“[email protected]”   -S smtp-auth-password=“password”   -S from=“[email protected]”   [email protected] 

2) sendmail / postfix / exim (system MTA)

• Description: Full Mail Transfer Agents installed on servers; accept local submission via sendmail-compatible interface.
• Install: apt: sudo apt install postfix (or exim4).
• Strengths: Good for high-throughput server-side sending, local queueing, and integration.
• Limitations: Requires configuration (DNS, SPF/DKIM) and maintenance.

Example (sendmail piping raw message):

Code
Copy CodeCopied
/usr/sbin/sendmail -t <<‘EOF’ From: [email protected] To: [email protected] Subject: Test message

 
Hello from sendmail. EOF 

3) msmtp

• Description: Lightweight SMTP client designed as a sendmail replacement; simple config per account.
• Install: apt: sudo apt install msmtp or macOS: brew install msmtp.
• Strengths: Simple config file, supports TLS and multiple accounts, easy to script.
• Limitations: No queueing — delivery attempted immediately.

Config (~/.msmtprc):

Code
Copy CodeCopied
# Example ~/.msmtprc defaults auth           on tls            on tls_trust_file /etc/ssl/certs/ca-certificates.crt

 
account default host smtp.example.com port 587 user [email protected] passwordeval “passman get smtp-password” from [email protected] 

Send command:

Code
Copy CodeCopied
echo -e “Subject: Test

 
Body” | msmtp [email protected] 

4) s-nail (modern heirloom / mailx alternative)

• Description: Enhanced mailx successor with improved features.
• Install: apt: sudo apt install s-nail.
• Strengths: Scriptable, supports attachments, MIME and SMTP auth.
• Example similar to mailx; prefer for richer features.

Example with attachment:

Code
Copy CodeCopied
echo “Body” | s-nail -s “Subject” -a /path/to/file –   -S smtp=“smtp://smtp.example.com:587”   -S smtp-auth=login   -S smtp-auth-user=“[email protected]”   -S smtp-auth-password=“password”   [email protected] 

5) swaks (Swiss Army Knife SMTP)

• Description: Diagnostic SMTP tool ideal for testing SMTP servers and authentication.
• Install: apt: sudo apt install swaks.
• Strengths: Verbose debugging, many auth and TLS options.
• Limitations: Mainly for testing rather than production scripting.

Example (AUTH PLAIN with TLS):

Code
Copy CodeCopied
swaks –to [email protected] –from [email protected]   –server smtp.example.com:587 –auth LOGIN   –auth-user [email protected] –auth-password ‘password’ –tls 

6) curl (SMTP support)

• Description: Modern curl supports SMTP(S) and can send messages using MIME.
• Strengths: Already available on many systems, supports OAuth bearer tokens and attachments via MIME.
• Example (simple):

Code
Copy CodeCopied
curl –url ‘smtp://smtp.example.com:587’ –ssl-reqd   –mail-from ‘[email protected]’ –mail-rcpt ‘[email protected]’   –user ‘[email protected]:password’   -T <(printf ‘Subject: Hi

 
Hello from curl ‘) 

• Example (attachment using –upload-file MIME):

Code
Copy CodeCopied
curl –url ‘smtps://smtp.example.com:465’ –user ‘user:password’   -T message.txt –upload-file message.txt –mail-from [email protected] –mail-rcpt [email protected] 

7) nodemailer-cli / Python SMTP / send via API

• Description: Use language-specific CLI scripts or API-based sending (SendGrid, Mailgun, Amazon SES).
• Strengths: API providers often simplify deliverability and authentication (API keys).
• Example (curl to Mailgun API):

Code
Copy CodeCopied
curl -s –user ‘api:YOUR_API_KEY’   https://api.mailgun.net/v3/YOUR_DOMAIN/messages
  -F from=‘Sender [email protected]’   -F to=‘[email protected]’   -F subject=‘Hello’   -F text=‘Test message’ 

Example command patterns (quick reference)

• Simple one-liner using msmtp:

Code
Copy CodeCopied
echo -e “Subject: Hi

 
Body” | msmtp [email protected] 

• Send with attachment (mailx/s-nail):

Code
Copy CodeCopied
s-nail -s “Subject” -a file.pdf [email protected] < body.txt 

• Use system sendmail:

Code
Copy CodeCopied
sendmail -t < message.eml 

• SMTP via curl:

Code
Copy CodeCopied
curl –url ‘smtp://smtp.example.com:587’ –ssl-reqd –user ‘user:pass’   –mail-from ‘[email protected]’ –mail-rcpt ‘[email protected]’   -T message.txt 

Security and deliverability checklist

• Use TLS/STARTTLS and strong passwords or OAuth.
• Prefer API-based sending for high deliverability (Mailgun, SendGrid, SES).
• Publish SPF and DKIM records and consider DMARC.
• Avoid putting raw passwords in scripts — use credential stores (pass, keyring, environment variables with restricted permissions).
• Monitor bounce and spam reports.

Troubleshooting tips

• Use verbose flags (-v, –debug, –trace) to see SMTP conversation.
• Check mail logs (/var/log/mail.log, /var/log/maillog) for MTA issues.
• Test connectivity: telnet smtp.example.com 587 or openssl s_client -connect smtp.example.com:465.
• If emails land in spam, check SPF/DKIM, message headers, and sending IP reputation.

Minimal recommended setup

• For simple scripts: msmtp + ~/.msmtprc with TLS and passwordeval.
• For server-side bulk sending: properly configured Postfix or an API provider (SES/Mailgun) for better deliverability.

If you want, I can generate ready-to-use config snippets for your SMTP provider (give the provider name or SMTP details) or an example script that integrates email sending into a cron job.

TZeditor vs. Competitors: Which Editor Wins in 2026?

Introduction TZeditor entered the editor market as a fast, extensible code and content editor focused on developer ergonomics and AI-assisted workflows. By 2026 the editor landscape is crowded—VS Code, JetBrains IDEs, Windsurf/Cursor (AI-first editors), Sublime, and specialized WYSIWYG frameworks (TinyMCE, ProseMirror, Lexical) all compete across different use cases. This article compares TZeditor to those competitors across core criteria and gives a practical recommendation for which tool “wins” depending on needs.

Key criteria

• Performance (startup time, memory use, responsiveness)
• Extensibility (plugins, APIs, marketplace)
• Language & tooling support (LSP, debuggers, terminals)
• AI features (code suggestions, repo-wide agents, refactors)
• Collaboration (real-time editing, shared sessions, PR integrations)
• UX & workflow (keyboard-driven productivity, UI design, accessibility)
• Platform & deployment (desktop, web, cloud IDE, browser)
• Security & privacy (local vs cloud processing, enterprise controls)
• Cost & licensing

Snapshot comparison (summary)

• TZeditor — Strong points: lightweight core, fast startup, opinionated keyboard-centric UX, first-class LSP support, a growing plugin ecosystem, built-in AI completions with configurable local/in-cloud inference, and competitive memory profile. Weaknesses: smaller marketplace, fewer enterprise plugins, collaboration features improving but not yet on par with leaders.
• VS Code — Strong points: unparalleled ecosystem, stable LSP and debugger integrations, huge marketplace, remote/WSL support. Weaknesses: heavier memory usage, extension bloat, and less opinionated workflows; AI features available via extensions but not agentic by default.
• JetBrains IDEs — Strong points: deep static analysis, integrated refactorings, mature debugging, best-in-class language-specific support (Java, Kotlin, Python via PyCharm). Weaknesses: heavier, commercial tiers,

Canon PIXMA MX7600: MP Navigator EX Setup, Troubleshooting & Download Links

Overview

MP Navigator EX is Canon’s scanning and document-management application for PIXMA printers, including the MX7600. It simplifies scanning, OCR, saving, and sharing documents and photos. This guide shows how to install MP Navigator EX, troubleshoot common issues, and where to download the software.

System requirements (general)

• Supported OS: Windows 7/8/10/11 and macOS (versions vary — check Canon download page for exact compatibility).
• Minimum 2 GB RAM recommended.
• USB 2.0 or network connection for your PIXMA MX7600.

Download links

• Canon support page (official): Visit Canon’s regional support site, search “PIXMA MX7600” and download MP Navigator EX from the Drivers & Downloads section.
• Alternative official sources: Canon USA / Canon Europe / Canon Asia support pages depending on your country.

(If a direct link is required, use Canon’s support site for your region to ensure the correct, up-to-date package.)

Installation — Windows

1. Turn on the PIXMA MX7600 and connect it to your PC via USB or ensure it’s on the same network.
2. Download the MP Navigator EX installer from Canon’s support page for MX7600.
3. Run the downloaded installer as Administrator (right-click → “Run as administrator”).
4. Follow on-screen prompts: accept license, choose installation type (typical recommended).
5. If drivers are included, allow driver installation. Reboot if prompted.
6. Open MP Navigator EX: set default scan settings, destination folders, and OCR language.

Installation — macOS

1. Turn on the MX7600 and connect via USB or network.
2. Download the macOS-compatible MP Navigator EX package from Canon support.
3. Open the .dmg/.pkg and run the installer; follow prompts, enter admin password if requested.
4. After installation, add the printer/scanner in System Settings → Printers & Scanners if not auto-detected.
5. Launch MP Navigator EX and configure preferences.

Basic usage

• Scan a document: Select document type (Photo/Document), choose scan settings (color/gray, resolution), click Scan.
• Save/Share: Use Save, Save as PDF, or Send via Email options in the app.
• OCR: Choose “Convert text” or “OCR” to extract editable text; verify OCR language matches document language.

Common troubleshooting

• MP Navigator EX doesn’t detect the scanner:
  • Ensure printer is powered on and connected (USB or network).
  • For USB, try a different port and cable.
  • For network, confirm printer and computer are on same subnet; temporarily disable VPN.
  • Reinstall drivers from Canon’s site.
• Scanner busy or locked by another app:
  • Close other scanning apps (Windows Fax and Scan, Image Capture on macOS).
  • Reboot both printer and computer.
• Installation fails or “incompatible OS”:
  • Download the latest driver/utility package for your OS version.
  • Run installer in Compatibility Mode (Windows) or check for macOS Gatekeeper prompts (System Settings → Security & Privacy).
• OCR produces errors:
  • Increase DPI to 300 or 600 for small/low-contrast text.
  • Use clear, well-lit originals; crop to margins.
  • Select correct OCR language and proofread output.
• Slow scanning:
  • Lower resolution if high DPI isn’t needed.
  • Use USB connection instead of slower wireless if possible.
• PDF saving or multi-page scan problems:
  • Ensure “Save as multi-page PDF” option is selected.
  • If PDFs are corrupted, reinstall MP Navigator EX and update PDF reader (Adobe Reader or Preview).

Advanced tips

• Batch scanning: Use feeder (if available) or scan multiple pages and combine into one multi-page PDF.
• Custom profiles: Save commonly used settings as profiles for quick access (resolution, file format, destination).
• Integration: Use MP Navigator EX with cloud services by saving files to a synced folder (Dropbox, OneDrive) for automatic upload.
• Driver alternatives: If MP Navigator EX is unsupported on very new OS versions, use the OS’s native scanner driver (WIA/TWAIN on Windows, ICA on macOS) with third-party scanning apps like NAPS2 (Windows) or VueScan.

When to contact Canon support

• Hardware scanning errors (e.g., paper feed jams, scanner light failures).
• Persistent connectivity issues after trying the steps above.
• If your OS is unsupported and you need official guidance or legacy downloads.

Quick checklist before contacting support

• Confirm MX7600 firmware is up to date.
• Reproduce the issue and note error messages.
• Try another computer to isolate PC vs printer problem.
• Have printer serial number and OS version ready.

If you want, I can provide direct download links for Canon support pages for your region — tell me your country and OS.

How to Use 4Musics CDA to MP3 Converter — Step-by-step Tutorial

Requirements

• Windows PC with a CD drive
• 4Musics CDA to MP3 Converter installed (assume default install folder)
• Audio CD to rip

Steps

1. Insert the audio CD into your computer’s CD/DVD drive.
2. Launch 4Musics CDA to MP3 Converter.
3. In the program, click Add or Open CD; the software should list tracks from the inserted CD (CDA entries).
4. Select the tracks you want to convert (check boxes or use Select All).
5. Choose MP3 as output format.
6. Set MP3 options:
   • Bitrate: 192–320 kbps for good quality (320 kbps = best).
   • Sample rate: 44100 Hz (CD standard).
   • Channels: Stereo.
7. Choose an output folder (Browse or Output Path).
8. (Optional) Edit metadata (title, artist, album, track number) before ripping.
9. Click Convert or Start to begin ripping; wait for the progress to finish.
10. After conversion, open the output folder to verify MP3 files play correctly.

Tips & Troubleshooting

• If tracks don’t appear, eject and reinsert the CD or restart the app.
• For gaps between tracks, enable any “gapless” or “trim silence” option if available.
• If audio quality is low, increase bitrate to 320 kbps.
• Use the program’s normalization option if volumes vary between tracks.
• If conversion fails, try running the app as Administrator or check CD for scratches.

Quick settings recommendation (general)

• Format: MP3
• Bitrate: 320 kbps
• Sample rate: 44100 Hz
• Channels: Stereo

If you want, I can write a short blog-style walkthrough or produce a checklist/printable one-page guide.

Legal & Ethical Checklist for the Photo Lottery Director

1. Confirm whether your event is a lottery, raffle, or sweepstakes

• Clarity: Determine which category fits your promotion — lotteries typically require payment to enter and are heavily regulated; raffles are often charitable and may have exemptions; sweepstakes usually award prizes without purchase. Treat this classification as the foundation for all legal decisions.

2. Verify applicable local, state, and national laws

• Jurisdiction: Laws vary by country and state. Confirm gambling, lottery, and charitable gaming statutes in every jurisdiction where tickets will be sold or entries accepted.
• Licenses & permits: Identify and obtain required licenses, permits, or registrations well before ticket sales begin.

3. Tax compliance and reporting

• Prize reporting: Understand reporting obligations for prize values (e.g., IRS Form 1099 in the U.S.) and withholdings if applicable.
• Sales/use tax: Check whether ticket sales are taxable and whether proceeds need segregated accounting for charitable portions.

4. Age restrictions and participant eligibility

• Minimum age: Set and enforce age limits consistent with law.
• Eligibility rules: Draft clear eligibility criteria (residency, nonprofit status, employees/executive exclusion).

5. Transparent rules and official terms

• Official rules document: Provide a written set of rules covering eligibility, entry method, prize descriptions, odds, draw date, winner selection, prize delivery, and dispute resolution.
• Accessibility: Post rules prominently on promotional materials and the event website; provide printed copies at point of sale.

6. Consent and privacy for photo use

• Photo release forms: Obtain written permission from entrants for use of photographs in promotion, specifying where and how images may be used.
• Privacy compliance: Collect only necessary personal data; comply with data-protection laws (e.g., GDPR, CCPA) for storage, transfer, and retention.
• Anonymity options: Offer an option to appear anonymously in promotional materials if feasible.

7. Fairness and anti-fraud measures

• Randomization: Use an auditable, documented random selection process (third-party drawing service or certified software).
• Recordkeeping: Keep logs of ticket sales, entries, draw procedure, and communications for the legally required retention period.
• Security: Secure tickets, digital entries, and prize inventory to prevent tampering or theft.

8. Prize verification and delivery

• Prize descriptions: Accurately describe prize condition, restrictions, and estimated retail value (including taxes or fees winners must pay).
• Delivery timeline: State how and when winners will receive prizes; include contingency plans for unclaimed prizes.
• Inspections/warranties: If prizes are items (e.g., camera gear), disclose warranty status and return or exchange policies.

9. Advertising and promotion rules

• Truthful marketing: Avoid misleading claims about odds, prizes, or charitable impact.
• Required disclosures: Include legally required disclaimers (e.g., “No purchase necessary” for sweepstakes).
• Third-party partnerships: Ensure partners and sponsors follow the same legal and ethical standards in promotions.

10. Charitable designation and fund use (if applicable)

• Charity verification: If promoting proceeds to a charity, confirm the charity’s status and permissions to use its name/logo.
• Fund allocation: Clearly state the portion of proceeds going to charity and how funds will be used; keep separate accounting.
• Reporting: Maintain transparent reporting to stakeholders and, if required, to regulators.

11. Conflict of interest and impartiality

• Staff exclusions: Prohibit board members, staff, and their families from participating if rules or law require.
• Disclosure: Disclose any relationships between organizers and prize donors or vendors.

12. Accessibility and reasonable accommodations

• Physical & digital access: Ensure entry methods and promotional materials are accessible to people with disabilities.
• Alternative entry methods: Provide a no-purchase required method where required by law.

13. Dispute resolution and complaints process

• Contact channel: Publish a clear process for handling disputes, complaints, or winner challenges.
• Arbitration/venue: Specify governing law and dispute-resolution forum in the official rules.

14. Insurance and liability

• Event insurance: Obtain liability insurance covering the draw event and prize-related incidents.
• Indemnities: Use vendor and sponsor agreements with indemnity clauses to limit organizational risk.

15. Post-event compliance and reporting

• Winner announcements: Announce winners in the manner promised and document notification attempts.
• Financial reporting: Reconcile ticket sales, expenses, and charitable distributions; file any required reports with regulators.
• Retention: Retain records according to legal retention schedules.

Quick implementation checklist (practical steps)

1. Confirm legal classification (lottery/raffle/sweepstakes).
2. Obtain necessary licenses/permits.
3. Draft and publish official rules and photo releases.
4. Set up secure sales and random-draw systems.
5. Verify tax obligations and accounting processes.
6. Purchase insurance and document vendor agreements.
7. Run draw with auditable process; notify and verify winners.
8. Distribute prizes and report results to regulators/charities.
9. Archive records and prepare post-event reports.

Follow these items as a baseline; consult local counsel for jurisdiction-specific requirements to ensure full legal compliance.

Ayrun: A Complete Beginner’s Guide

What Ayrun Is

Ayrun is a [concise description assumed: productivity tool/platform/service]. It helps users streamline tasks, organize information, and automate repetitive workflows across devices and apps.

Key Features

• Task Management: Create, assign, and track tasks with deadlines and priorities.
• Automation: Set rules and triggers to automate routine actions (e.g., move items, send notifications).
• Integrations: Connects with common apps (calendars, email, cloud storage) to centralize work.
• Collaboration: Shared boards, comments, and real-time updates for team coordination.
• Analytics: Dashboard with usage stats and productivity insights.

Who It’s For

• Individuals wanting a single place for tasks and reminders.
• Small teams needing lightweight project coordination.
• Power users who automate workflows across multiple apps.

Getting Started (Step-by-step)

1. Sign up and verify your account.
2. Create a workspace or project for your first set of tasks.
3. Add tasks or import from email/calendar.
4. Set deadlines, priorities, and assignees.
5. Create one simple automation (e.g., mark completed tasks archived).
6. Invite collaborators and assign roles.
7. Explore analytics after a week to adjust workflows.

Tips for Beginners

• Start with one project to avoid overload.
• Use templates for recurring project types.
• Keep task names short and action-oriented.
• Automate only high-frequency, low-importance tasks first.
• Review and prune tasks weekly.

Common Questions

• Is Ayrun free? Many platforms offer a free tier; assume basic features are available without cost.
• Is there mobile support? Expect mobile apps or a responsive web interface.
• Can I import data? Most platforms allow imports from CSV or direct integrations.

Next Steps

• Explore templates and pre-built automations.
• Link your calendar and email for smoother task capture.
• Gradually expand team access and automate recurring processes.

If you want, I can write a walkthrough tailored to a specific use case (personal productivity, small team, or developer workflows).

Batch XML to Plain Text Converter Tool — Export, Clean & Save Multiple Files

Key features

• Batch processing: Convert hundreds or thousands of XML files in one run to plain .txt files.
• Custom extraction rules: Define XPath or tag-based rules to extract only the elements or attributes you need.
• Tag removal & cleanup: Strip XML tags, comments, and namespaces; normalize whitespace and line breaks.
• Preserve structure options: Optionally retain simple delimiters (tabs, commas, or custom separators) to show original hierarchy.
• Encoding support: Detect and convert between UTF-8, UTF-16, ISO-8859-1, and other common encodings.
• Filename mapping & output folders: Auto-generate filenames from XML elements or attributes; save to organized folder structures.
• Error handling & logging: Skip or retry malformed files with detailed logs and optional error reports.
• Automation & scheduling: Command-line interface and task scheduler integration for recurring conversions.
• Preview & test mode: Sample conversion preview before running full batches to validate extraction rules.
• Performance & memory options: Stream-based parsing for large files to minimize memory usage.

Typical workflow

1. Add source folder or select individual XML files.
2. Define extraction rules (XPath, tag list, or default full-text extraction).
3. Choose output format (plain .txt, delimiter-separated, or custom template).
4. Set filename mapping and destination folder.
5. Run a preview on sample files and adjust rules if needed.
6. Execute batch conversion; review logs for errors and summary.

Best use cases

• Migrating XML-based content to legacy systems that accept plain text.
• Preparing XML data for text analysis, indexing, or search engines.
• Cleaning and exporting extracted fields for CSV/flat-file imports.
• Automating recurring exports from XML feeds or nightly data dumps.

Tips for reliable results

• Use XPath expressions for precise extraction when XML structure varies.
• Test on representative samples to catch namespace or encoding issues.
• Enable stream parsing for very large XML files to avoid high memory use.
• Configure meaningful filename templates (e.g., using an ID or date element) to prevent collisions.

Limitations to watch for

• Complex nested structures may require multiple extraction passes or custom templates.
• Poorly formed XML can fail conversion; robust error handling and validation help.
• Some semantic relationships (parent-child context) may be lost when flattening to plain text.

If you want, I can generate sample XPath rules or a command-line example for a specific XML layout.

OraCmd: The Lightweight CLI for Oracle Database Management

OraCmd is a compact, command-line utility designed to simplify everyday Oracle Database tasks for DBAs and developers. It focuses on speed, clarity, and automation-friendly output so you can perform routine operations without the overhead of heavyweight GUIs or complex client installations.

Why choose OraCmd

• Lightweight: Minimal dependencies and a small binary make installation quick and portable.
• Scriptable: Predictable, machine-readable output (JSON/CSV/plain) eases integration into shell scripts and automation pipelines.
• Focused feature set: Covers common DBA tasks without the bloat of full-featured database clients.
• Cross-platform: Works on Linux, macOS, and Windows (via WSL or native builds).

Key features

• Connection short-hands and secure credential handling
• Quick SQL execution with configurable timeouts
• Schema inspection: list tables, indexes, constraints, and column metadata
• User and role management helpers (create/drop/grant/revoke)
• Export/import helpers for CSV and JSON
• Health checks and lightweight monitoring queries
• Transaction helpers with explicit commit/rollback shortcuts
• Output formatting and paging for interactive use

Typical use cases

1. Ad-hoc queries from a script: run SQL and parse JSON output for downstream processing.
2. Database health checks: run a set of diagnostic queries and return non-zero exit codes on failures for monitoring systems.
3. Quick schema audits: generate CSV reports of table sizes, index usage, and missing constraints.
4. Dev/test workflows: spin up connection aliases and run migration SQL from CI jobs.
5. Emergency fixes: connect quickly to a production instance for urgent DDL or user fixes.

Example commands

• Connect with a named profile:

Code
Copy CodeCopied
oracmd connect prod-db 

• Run a SQL file and output JSON:

Code
Copy CodeCopied
oracmd exec –file migrate.sql –format json 

• List tables and sizes in a schema:

Code
Copy CodeCopied
oracmd schema list –owner hr –details 

• Create a user with a limited lifespan:

Code
Copy CodeCopied
oracmd user create –username tempdev –password Xx!123 –expire 7d 

Code
 ffON2NH02oMAcqyoh2UU MQCbz04ET5EljRmK3YpQ CPXAhl7VTkj2dHDyAYAf” data-copycode=“true” role=“button” aria-label=“Copy Code”>Copy CodeCopied
oracmd health run –script checks.sql 

Code
Copy CodeCopied
oracmd exec –query “SELECT table_name, num_rows FROM user_tables” –format json | jq ‘.[] | select(.numrows == 0)’ 

Code
 ffON2NH02oMAcqyoh2UU MQCbz04ET5EljRmK3YpQ CPXAhl7VTkj2dHDyAYAf” data-copycode=“true” role=“button” aria-label=“Copy Code”>Copy CodeCopied
oracmd profile add –name prod-db –host db.example.com –port 1521 –service ORCL –user admin 

Code
Copy CodeCopied
oracmd connect prod-db –ping 

Code
Copy CodeCopied
oracmd exec –query “SELECT sysdate FROM dual” –format plain