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

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 get age from birth date in Oracle SQL

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

What is Siebel

What is Siebel? Siebel is a Customer Relationship Management application (CRM). It is mainly used by companies (e.g. Telecommunication, p...

What is CRM (Customer Relationship Management)

As per Salesforce below is the definition of CRM: Customer relationship management is an approach to manage a company's interaction w...