Find slow running queries on MS SQL Server

Source Below query will helps you find the queries which have taken a lot of time in milliseconds. To confirm that you have query performanc...

How to check Communications Outbound Manager jobs status SQL

When using " Communications Outbound Manager " business service Siebel create a job record in " S_SRM_REQUEST " table. Y...

How to remove Line Break when selecting data from SQL Server

When you run SELECT query and copy the result to notepad or excel instead of one row columns with new line character shifts to new row. char...

How to create SQL DB Views in MS SQL Server

This Article will cover below points: How to create DB View in Microsoft SQL Server. How to provide permissions to DB View. How to export DB...

SQL Command Types

Data Defination Language (DDL) Create  Alter  Rename Truncate  Drop  Data Query Language (DQL) Select  Data Manipulation Language (DML) Inse...

Oracle SQL concatenate multiple columns and add text

You have two options for concatenating strings and column values in Oracle: CONCAT Using || CONCAT example: select CONCAT(ROW_ID,'text...

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

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

How to get age from birth date in Oracle SQL

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

How to get Siebel user responsibilities from database through Sql query

SELECT u.LOGIN as "User ID" ,res.NAME as "Responsibility" FROM S_USER u left join S_PER_RESP ri on ri.PER_ID = u.R...

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