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...

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...

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...

SQL Developer INSERT INTO SELECT Statement

With INSERT ... SELECT , you can quickly insert many rows into a table from the result of a SELECT statement, which can select from one or m...

How to get Host Address and Servcie Name from Oracle database

 The IP address of the database server:  select UTL_INADDR.get_host_address from dual   Get Service Name select * from global_name;  

How to get Service Name through Oracle Oracle Developer

To see what services are available in the database use following queries: select name from V$SERVICES ; select name from V$ACTIVE_SERVICES...

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...

How to get age from birth date in Oracle SQL

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