Instant Oracle Database and PowerShell How-to - Instant Oracle Database and PowerShell How-to - page 56

8. Get the DEPARTMENTS table and initialize it:

PS > $deptTable = $tables["DEPARTMENTS"]
PS > $deptTable.Initialize()

9. Display column information for the DEPARTMENTS table:

PS > $deptTable.Columns | ft -auto Ordinal,Name, IsNullable,
>> @{Label="Type"; Expression={"{0} ({1})" -f $_.DataType.
OracleType, $_.DataType.Size}}
>>

Ordinal Name IsNullable Type
------- ---- ---------- ----
1 DEPARTMENT_ID False NUMBER (0)
2 DEPARTMENT_NAME False VARCHAR2 (30)
3 MANAGER_ID True NUMBER (0)
4 LOCATION_ID True NUMBER (0)

10. Generate a CREATE TABLE script for DEPARTMENTS :
PS > $deptTable.GetCreateSQLs($true)[0]
CREATE TABLE "HR"."DEPARTMENTS" (
"DEPARTMENT_ID" NUMBER(4,0) NOT NULL,
"DEPARTMENT_NAME" VARCHAR2(30 BYTE) NOT NULL,
"MANAGER_ID" NUMBER(6,0) NULL,
"LOCATION_ID" NUMBER(4,0) NULL,
CONSTRAINT "DEPT_LOC_FK"
FOREIGN KEY ( "LOCATION_ID")
REFERENCES "HR"."LOCATIONS" ( "LOCATION_ID")
ENABLE
VALIDATE,
CONSTRAINT "DEPT_MGR_FK"
FOREIGN KEY ( "MANAGER_ID")
REFERENCES "HR"."EMPLOYEES" ( "EMPLOYEE_ID")
ENABLE
VALIDATE)
STORAGE (
NEXT 1048576 )

11. Get DEPARTMENT table data and ilter it down:
PS > $deptDS = $deptTable.GetData($true)
PS > $deptDS.Tables["DEPARTMENTS"] | ? {$_.department_id -lt 40} |
ft -auto DEPARTMENT_ID, DEPARTMENT_NAME

DEPARTMENT_ID DEPARTMENT_NAME
------------- ---------------
10 Administration
20 Marketing
30 Purchasing