Generating a random integer in PL/SQL.

-
The below function is quite helpful when you need to generate a random number:

set serveroutput on
declare
   l_num    number;
   startNumber NUMBER := 1;
   endNumber NUMBER := 10;
begin
    l_num :=round(dbms_random.value(startNumber,endNumber));
    dbms_output.put_line(l_num);
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