< Back
Get-OracleSQLText
Post
NAME Get-OracleSQLText
SYNOPSIS
Query an Oracle database to get the text of a certain query
SYNTAX
Get-OracleSQLText [-TargetDB] <String> [-SqlId] <String> [-SQLFilter <String>] [-DBUser <String>]
[-PasswordPrompt] [-ErrorLog] [-ErrorLogFile <String>] [<CommonParameters>]
DESCRIPTION
This function returns the text of a certain query based on SQL ID provided
PARAMETERS
-TargetDB <String>
Target Database
Required? true
Position? 1
Default value
Accept pipeline input? true (ByValue, ByPropertyName)
Accept wildcard characters? false
-SqlId <String>
Required? true
Position? 2
Default value
Accept pipeline input? true (ByValue, ByPropertyName)
Accept wildcard characters? false
-SQLFilter <String>
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-DBUser <String>
Username if required
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-PasswordPrompt [<SwitchParameter>]
Flag to ask for a password
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-ErrorLog [<SwitchParameter>]
Switch to turn on the error logging
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-ErrorLogFile <String>
Required? false
Position? named
Default value "$env:TEMP\\OracleUtils_Errors_$PID.log"
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
-------------------------- EXAMPLE 1 --------------------------
PS C:\\>Get-OracleSQLText -TargetDB myorcl -SqlId some123id
RELATED LINKS
SYNOPSIS
Query an Oracle database to get the text of a certain query
SYNTAX
Get-OracleSQLText [-TargetDB] <String> [-SqlId] <String> [-SQLFilter <String>] [-DBUser <String>]
[-PasswordPrompt] [-ErrorLog] [-ErrorLogFile <String>] [<CommonParameters>]
DESCRIPTION
This function returns the text of a certain query based on SQL ID provided
PARAMETERS
-TargetDB <String>
Target Database
Required? true
Position? 1
Default value
Accept pipeline input? true (ByValue, ByPropertyName)
Accept wildcard characters? false
-SqlId <String>
Required? true
Position? 2
Default value
Accept pipeline input? true (ByValue, ByPropertyName)
Accept wildcard characters? false
-SQLFilter <String>
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-DBUser <String>
Username if required
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-PasswordPrompt [<SwitchParameter>]
Flag to ask for a password
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-ErrorLog [<SwitchParameter>]
Switch to turn on the error logging
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-ErrorLogFile <String>
Required? false
Position? named
Default value "$env:TEMP\\OracleUtils_Errors_$PID.log"
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
-------------------------- EXAMPLE 1 --------------------------
PS C:\\>Get-OracleSQLText -TargetDB myorcl -SqlId some123id
RELATED LINKS