ITCanopy

Below is the query to create user for Siebel Application with SQL Query in Oracle SQL Developer create user <username> identified by "<password>"; grant <privilege> to <user> CREATE USER "ATIF" IDENTIFIED BY "ATIF"; GRANT SSE_ROLE TO "ATIF"; Commit and all done.

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

To see what services are available in the database use following queries: select name from V$SERVICES ; select name from V$ACTIVE_SERVICES ; The V$ views are mainly dynamic views of system metrics. They are used for performance tuning, session monitoring, etc. So access is limited to DBA users by default The easiest way of finding the database name is: select * from global_name ; This view is granted to PUBLIC, so anybody can query it.

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

What is Siebel? Siebel is a Customer Relationship Management application (CRM). It is mainly used by companies (e.g. Telecommunication, pharmaceutical or Banking sector) which have huge customers and have regular interaction with them. Siebel offers a hybrid model for organizations, giving them the option of working offline, hosted (by Oracle or by client organization) or on premises. (Wikipedia) Founded: 1993, California, United States Defunct: 2006 Headquarters: San Mateo, California, United States Successor: Oracle Corporation Founders: Thomas Siebel, Patricia House Parent organization: Oracle Corporation There are other CRM like Sugar CRM, Microsoft Dynamics CRM and Sales Force CRM. What is CRM (Customer Relationship Management)? (Salesforce) Customer relationship management is an approach to manage a company's interaction with current and potential customers.

As per Salesforce below is the definition of CRM: Customer relationship management is an approach to manage a company's interaction with current and potential customers. It uses data analysis about customers' history with a company to improve business relationships with customers, specifically focusing on customer retention and ultimately driving sales growth.