Useful SQL queries.

-
I found the below queries to be quite useful when working in the SQL or PL/SQL environment:

You can run this query to get the database parameters:
select * from v$parameter;

To get the number of sessions for AB:
select * from  AB.ps_txn order by creation_date;

Find all tables and filter them out by containing SEARCH_CRITERIA:
select owner, table_name from dba_tables where table_name like '%SEARCH_CRITERIA%' order by table_name desc;

Get table data:
desc TABLE_NAME;

Get all DB users with username UNAME:
select * from dba_users where username like '%USERNAME%'

Select 1% of table contents:
select * a_table sample (1);

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