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

$(gc $filename -readcount 0 | Out-String)
commit;
exit
"@
}

6. Deine a helper function to create a new directory:
function New-Directory($dir) {
if (!(test-path $dir)) {
new-item $dir -type directory | Out-Null
}
}

7. In the folder of SqlPlus.ps1 , create a subfolder named HR

8. In a DBMS tool, connect to the sample HR database of Oracle Express and expand

Procedures in the HR schema. Select ADD_JOB_HISTORY and SECURE_DML and
export the DDL to a combined Procs.sql ile in the HR folder. Likewise export
EMP_DETAILS_VIEW to EMP_DETAILS_VIEW.sql .

9. Execute the script and supply a TNS name and a password when prompted:

10. Verify the LAST DDL date was updated on these objects in the database.
11. Explore the Logs directory created and open the log iles: