Print out to screen in PL/SQL.

-
Here are some PL/SQL commands that I found to be quite useful when needing to print something out: (Note: set serveroutput on sets output on):

1)

set serveroutput on 
begin
  dbms_output.put_line('hi');
end;
/

or

2)

create procedure p_say_something
as
begin
dbms_output.put_line('hi');
end;
/

 set serveroutput on 

 begin
 p_say_something;
end;
/

Comments

Post a Comment

Popular posts from this blog

Whitelist an Azure firewall IP using PowerShell

-
  1. Connect via PowerShell in Azure portal: PS /home/azureuser> Connect-AzAccount -UseDeviceAuthentication 2. Run in PowerShell: PS /home/azureuser>$new_ip = (Invoke-WebRequest ifconfig.me/ip).Content; Set-AzSqlServerFirewallRule -ResourceGroupName "<res_group_name>" -ServerName "<server_name>" -FirewallRuleName "test" -StartIpAddress "$new_ip" -EndIpAddress "$new_ip";
Read more

Excel: highlighting a row or a column based a value, the current date example.

-
Image
Sometimes you need to to be able to look at your spreadsheet and quickly see the row or column relate to a certain value. Conditional highlighting will definitely help with that. I will show using the current date as an example. Select the working range. Go to Conditional Formatting. Set the formula: The dollar sign ($) will anchor either a row (A$1) or a column ($A1), so that the formula will be applied to, respectively, all the columns in the anchored row or all the rows in the anchored column.  Click Format and select the highlighting effects that you need. Click OK and observe the highlighted row or a column:
Read more