How to delete Siebel Workflow Instance monitor logs SQL Developer
Workflow instance monitor have three separate tables. One for logging workflow run (workflow instance), second for its steps execution to lo...
Read More →
How to increse font size in Oracle SQL Developer
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 t...
Read More →
How to import a CSV file into SQL Developer
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 De...
Read More →
Oracle SQL concatenate multiple columns and add text
You have two options for concatenating strings and column values in Oracle: CONCAT Using || CONCAT example: select CONCAT(ROW_ID,'text...
Read More →
How to create SQL Views in SQL Developer from UI
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. V...
Read More →
How to get age from birth date in Oracle SQL
ROUND(months_between(TRUNC( sysdate ),to_date( CON.BIRTH_DT ))/12, 2)
Read More →