ITCanopy

Workflow instance monitor have three separate tables. One for logging workflow run (workflow instance), second for its steps execution to log (workflow steps) and third for logging the values of each process property value against each step of workflow (workflow process properties). If you increase the Workflow Monitoring level over the time tables space and DB load will be increase and sometimes instance monitor will be stopped working (Check Siebel Workflow Instance Monitor not working to fix this issue) . Its a good practice to delete the old workflow instance monitor records. Below are the queries for deleting the data. Its better to delete only old data and Year is perfect condition. Workflow Instance select count(*) from S_WFA_INST_LOG where EXTRACT(YEAR FROM TO_DATE(created))='2022' --delete from S_WFA_INST_LOG where EXTRACT(YEAR FROM TO_DATE(created))='2022' Workflow Instance Steps select count(*) from S_WFA_INSTP_LOG where EXTRACT(YEAR FROM TO_DATE(created))=...

In Oracle SQL Developer go to Tools and select Preferences. In New window go to Code Editor and expand, select Fonts. Change the font side to desired.

Title: How to import a CSV file into SQL Developer? Loading Data into a Table Procedure: After create a connection to the database in SQL Developer. 1. Right click on tables folder and Choose Import data. 2 .Select xls. 3. Follow the wizard     - Provide table name     - Select columns     - Define datatype per column and provide the length     - Finish.

You have two options for concatenating strings and column values in Oracle: CONCAT Using || CONCAT example: select CONCAT(ROW_ID,'text') from s_contact; Using || example: select ROW_ID || 'text' from s_contact; Source: StackOverflow

 About DB Views: Views are customized presentations of data in one or more tables or other views. You can think of them as stored queries. Views do not actually contain data, but instead derive their data from the tables upon which they are based. These tables are referred to as the base tables of the view. Similar to tables, views can be queried, updated, inserted into, and deleted from, with some restrictions. All operations performed on a view actually affect the base tables of the view. Views can provide an additional level of security by restricting access to a predetermined set of rows and columns of a table. They can also hide data complexity and store complex queries. Create Views: Open SQL Developer and connect the connection (DEV, UAT, Prod), Write the desired query. Now expand the db and find the Views and right click and select the "New View" A new window will appear. Paste the query your have prepared before and provide the appropriate new and click on OK button....

 ROUND(months_between(TRUNC( sysdate ),to_date( CON.BIRTH_DT ))/12, 2)