How to get List of values LOVs of Siebel from Database through SQL Query

SELECT TYPE AS 'Type' ,VAL AS 'Display Value' ,NAME AS 'Language-Independent Code' ,LANG_ID AS 'Language Na...

How to change length of Column through SQL query in Siebel

Get Row Id of Column from Siebel Tools and replace below: SELECT ROW_ID, NAME AS 'Column Name', LENGTH AS 'Column Length...

Siebel DB Backup through SQL Query

Replace values in highlighted with lime color according to your configuration. BACKUP DATABASE [SiebelDB] TO DISK = N' E :\\ Fold...

How to unlock Workflow in Siebel Tools from Database Table through SQL query

Background: For working on an object in Siebel tools you need to lock it and usually developer forget to unlock after working on the object....

How to get Siebel Workflow Instance Monitor values from Database through SQL query

Below is the query for getting workflow instance monitor values from table: select wfdl.NAME as 'WF Name' ,wfdl.DEPLOY_STATUS_C...

How to get Email profile parameters (like password) from Siebel DB using sql query

1. Open MS SQL Management Studio copy paste below query in query window. SELECT Prof.NAME AS 'Profile Name' ,ParNam.NAME AS ...

All Outbound Request in Siebel SQL Query

--All Outbound Requests-- SELECT SCR.REQ_NUM AS 'Request #' ,SCR.STATUS_CD AS 'Status' --,SCR.CM_SRVR_COMP_NAME AS ...

Find SQL Table Fragmentation

For checking table fragmentation use below: DBCC SHOWCONTIG ('S_CONTACT') DBCC SHOWCONTIG (tablename) DBCC SHOWCONTIG (tablen...

How to get column details in SQL from Siebel DB

Below query will return column details: SELECT COL.ROW_ID AS 'Column Id' ,COL.NAME AS 'Column Name' ,COL.LENGTH AS ...

How to convert date difference into years in SQL

Add below in your SQL query and it will get date difference and convert into years: (DATEDIFF(MONTH,TABLE.BIRTH_DT,CURRENT_TIMESTAMP)/12...

How to convert date difference into days in SQL

Add below in your SQL query and it will subtract date column from today's date and convert into days: CONVERT(INT, GETDATE() - TA...

SQL Structured Query Language

SQL : Structured Query Language SQL is used for storing, retrieving and manipulating (managing data) data in databases (MySql, Oracle, Sy...