Bulk upload a CSV into Microsoft SQL Server

Capture the name of the current Schema (aka User or Account) as part of the SPOOL Output filename

Run DB Stats for your Schema

Since Oracle 11g statistics are gathered automatically by default. You can see for yourself:

Run Oracle Database Statistics

-- Show me what GRANTs and Privileges I have on an object, such as a Table, View, Sequence, Stored Procedure

See database settings. Client will override Database.

Maybe your Client ins in one Time Zone, and your Database Server is in an0ther?

Convert Oracle TIMESTAMP Column from one Time Zone to another.

Here we convert UTC (aka GMT) to MDT (Mountain Time Zone of North America)

Get the Number of Rows in all your Tables

Here for example we show the default NLSLENGTHSEMNATICS Parameter

You might want to change all VARCHARs from BYTE to CHAR?

Maybe you want to change BYTE to CHAR? Maybe you want to go BIGGER?

Can be run as SQL or Create as a PL/SQL Procedure

To move a Table to another Tablespace, its Index must be rebuilt!