TopMiniSite
-
4 min readTo trim leading zeroes in comma separated values in Oracle, you can use the LTRIM function. This function removes all leading occurrences of a specified character (in this case, '0') from a string.You can achieve this by first splitting the comma separated values into individual strings using the SPLIT function or a similar method. Then, you can apply the LTRIM function to each individual string to remove the leading zeroes.
-
3 min readTo drop multiple columns from a dataframe using pandas, you can simply use the .drop() method and pass a list of column names that you want to remove as the labels parameter. For example, if you have a dataframe df and you want to drop columns named 'column1' and 'column2', you can use the following code: df.drop(['column1', 'column2'], axis=1, inplace=True). This will drop the specified columns from the dataframe inplace.
-
6 min readTo enable autocommit in Oracle permanently, you need to modify the database configuration settings. By default, Oracle does not have autocommit enabled, so you will need to update the database parameters to ensure that changes are automatically committed after each transaction. This can be done by setting the 'autocommit' parameter to 'ON' in the Oracle database configuration file.
-
4 min readTo restore values between other values in pandas, you can use the fillna() method along with the method parameter. This parameter allows you to specify a method for filling the missing values in a DataFrame. By using a method like bfill (backward fill) or ffill (forward fill), you can effectively restore values between other values in a DataFrame. This is particularly useful when dealing with missing or NaN values in a dataset.
-
8 min readTo bind Oracle params in Scala, you can use the Oracle JDBC driver to connect to the database and execute SQL queries that contain parameters. To bind parameters, you can use prepared statements, which allow you to set parameters before executing the query. You can use the set methods on the prepared statement object to bind parameters by index or name. Here's an example of how you can bind Oracle params in Scala: import java.sql.
-
4 min readTo filter data in a list of pandas dataframes, you can use the .loc[] method along with conditional statements to extract the desired data. You can specify the conditions inside the square brackets of .loc[] to filter rows based on specific criteria. For example, you can filter rows where a certain column has values greater than a certain threshold or where multiple conditions are met simultaneously. By applying the .
-
5 min readTo truncate the format yyyy/mm/dd hh:mm:ss.sss to mm/dd/yyyy in Oracle, you can use the TO_CHAR function to convert the date to the desired format. Here is an example query to achieve this:SELECT TO_CHAR(TO_DATE('2022/01/15 15:30:45.123', 'YYYY/MM/DD HH24:MI:SS.FF'), 'MM/DD/YYYY') AS truncated_date FROM dual;This query will take a date in the format yyyy/mm/dd hh:mm:ss.sss, convert it to the mm/dd/yyyy format, and return the truncated date.
-
4 min readTo join two tables from two columns in Oracle, you can use the JOIN keyword in your SQL query. The syntax for joining two tables on two columns is as follows:SELECT * FROM table1 INNER JOIN table2 ON table1.column1 = table2.column1 AND table1.column2 = table2.column2;In this example, table1 and table2 are the names of the tables you want to join, column1 and column2 are the names of the columns you want to join on.
-
2 min readTo concatenate two strings from two queries in Oracle, you can use the concatenation operator (||). Here is an example: SELECT query1.column1 || query2.column2 AS concatenated_string FROM query1, query2 WHERE query1.id = query2.id; This will concatenate the values of column1 from query1 and column2 from query2 into a single string and display it as concatenated_string in the result set.[rating:dc3bb8f1-bf14-46f8-a39b-16fc925c6a8c]How to concatenate strings from different columns in Oracle.
-
4 min readTo check the month and year of a procedure in Oracle, you can use the EXTRACT function to extract the month and year from a date column in your procedure.
-
5 min readIn Elixir, you can share data between worker processes by using the various built-in features of the language, such as message passing and process linking. One common way to share data between worker processes is by sending messages between them using the send/2 and receive/1 functions. You can also use the spawn_link/1 function to link processes together, so that if one process crashes, the other processes linked to it will also be terminated.