TopMiniSite
-
4 min readTo convert hex values to base64 in Oracle, you can use the UTL_ENCODE package provided by Oracle. You can use the HEXTORAW function to convert the hex value to binary and then use the BASE64_ENCODE function to convert it to base64.Here is an example SQL query that demonstrates how to convert a hex value to base64: SELECT UTL_RAW.CAST_TO_VARCHAR2(UTL_ENCODE.BASE64_ENCODE(UTL_RAW.
-
3 min readTo edit and save XML nodes with PowerShell, you can use various cmdlets such as Select-Xml, Set-Content, and Select-String. First, load the XML file by using the Select-Xml cmdlet and specifying the XPath query to target the desired nodes. Then, make the necessary changes to the node values using Set-Content cmdlet to update the XML file. Finally, save the modifications by using the Select-Xml cmdlet again to ensure the changes are reflected in the XML file.
-
6 min readTo include null records in an Oracle query, you can use the IS NULL operator in your WHERE clause. This operator allows you to specifically search for columns that have null values. For example, you can write a query like:SELECT * FROM table_name WHERE column_name IS NULL;This query will return all records where the specified column has a null value. Remember to replace "table_name" and "column_name" with the actual names of your table and column.
-
3 min readTo create a function in a PowerShell script, you can use the function keyword followed by the name of the function and a set of curly braces {} to define the code inside the function. You can then call the function by using its name followed by parentheses ().For example, to create a simple function that prints a message, you can use the following syntax: function SayHello { Write-Host "Hello, World.
-
5 min readTo iterate over a binary string in Oracle, you can use a loop structure to extract and process individual bits of the binary string. You can convert the binary string to a VARCHAR2 data type and then access each character in the string using a loop. By iterating over the characters of the binary string, you can perform any necessary operations on each bit of the binary data.
-
4 min readTo create a nested JSON object from XML data in Oracle, you can use the JSON_OBJECT function along with the XMLTABLE function. First, you need to query the XML data and convert it into a JSON object using XMLTABLE to extract the data fields. Then, you can use JSON_OBJECT to create the nested JSON object structure by specifying the key-value pairs and nesting them as needed. Finally, you can convert the JSON object into a JSON string using the JSON_QUERY function if needed.
-
4 min readTo replace a string with a newline in Oracle, you can use the REPLACE function along with the CHR function. The CHR(10) function creates a newline character in Oracle.
-
4 min readTo get the previous working date using trunc(sysdate) in Oracle, you can use a combination of functions and logic. One approach is to subtract 1 day from the current date (trunc(sysdate) - 1) and then check if the result falls on a weekend (Saturday or Sunday). If it does, you continue to subtract days until you reach a working day (Monday to Friday).
-
5 min readTo list all users with the "SELECT ANY TABLE" permission in Oracle, you can query the DBA_SYS_PRIVS view in the Oracle database. This view contains a list of all system privileges granted to users and roles in the database. By querying this view, you can identify which users have been granted the "SELECT ANY TABLE" privilege and hence have the ability to select data from any table in the database.
-
5 min readTo find exact match records with no duplicates in Oracle, you can use the SELECT statement along with the DISTINCT keyword.For example, you can write a query like this:SELECT DISTINCT column1, column2 FROM table_name WHERE column1='value1' AND column2='value2';This query will return only the unique records that exactly match the specified values in the columns column1 and column2, with no duplicates.
-
3 min readTo query data group by with order by in Oracle, you can use the following syntax:SELECT column_name1, column_name2, aggregate_function(column_name) FROM table_name GROUP BY column_name1, column_name2 ORDER BY column_name1, column_name2;In this syntax, replace "column_name1, column_name2" with the column names you want to group by and order by. The aggregate_function() can be any aggregate function like SUM, COUNT, AVG, etc.