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 create external table in Siebel Tools through Siebel Wizard

  What is external table in Siebel: "External Table" in the Siebel is used by " External Business Component (EBC)". EBC...

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