ITCanopy

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.

Add below in your SQL query and it will get date difference and convert into years: (DATEDIFF(MONTH,TABLE.BIRTH_DT,CURRENT_TIMESTAMP)/12) The DATEDIFF() function returns the difference between two dates. DATEDIFF(Interval, date_1, date_2) The CURRENT_TIMESTAMP() function returns the current date and time. SELECT CURRENT_TIMESTAMP()

SQL : Structured Query Language SQL is used for storing, retrieving and manipulating (managing data) data in databases (MySql, Oracle, Sybase, MS Access). SQL is a query language, not a programming language. The SQL language is divided into queries, clauses and statements etc. It helps consumer (user) to describe and manipulate the data. Importance SQL is used for the query, insert, collect and manages data from the database. It store and fetch data from database immediately. It helps to find the needed data (information) easily. You can easily write commands almost same as we write English as it is a query language not a programming language. Almost every database system needs SQL for processing. Reasons to learn Easy to learn It doesn't require coding (SQL manages the database system by using standard SQL). You can run SQL on laptop, servers, e.t.c. SQL Standard (Databases are used by established standards. ANSI in 1986 and ISO in 1987). SQL defines foll...