How to create a user in DB Oracle SQL Developer
Below is the query to create user for Siebel Application with SQL Query in Oracle SQL Developer create user <username> identified by ...
Read More →
Siebel Workflow Instance Monitor not working
Issue Details: In "Active Workflow Processes" Monitoring Level of workflow is set to "3 - Detail" but when check the ...
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 →
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...
Read More →
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;
Read More →
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...
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 →