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. Views do not actually contain data, but instead derive their data from the tables upon which they are based. These tables are referred to as the base tables of the view.

Similar to tables, views can be queried, updated, inserted into, and deleted from, with some restrictions. All operations performed on a view actually affect the base tables of the view. Views can provide an additional level of security by restricting access to a predetermined set of rows and columns of a table. They can also hide data complexity and store complex queries.

Create Views:

Open SQL Developer and connect the connection (DEV, UAT, Prod), Write the desired query. Now expand the db and find the Views and right click and select the "New View"

A new window will appear.

Paste the query your have prepared before and provide the appropriate new and click on OK button. Your view will be created.

Now you need to provide the privileges to your view (SSE_ROLE/ Select). Find your newly created view by expanding the Views. Right click and high light the "Privileges" and new child will appear, select "Grant"

New window will open, find SSE_ROLE (or the role your are using while creating the users) and select. Option will available, move "SELECT" to right box by using right single arrow and click on "Apply" button. All done.

You can use this view in your queries or create external table in Siebel on this view. For creating external table you need to export the "DDL" file and import in Siebel Tools. Right click on the view and high light the "Quick DDL" child will appear from that click on "Save to file". A new window will appear asking for the file name and the location where you want the save ".sql" file.

Display views:

In the Connections navigator in SQL Developer, navigate to the Views node for the schema that includes the view you want to display.

If the view is in your own schema, navigate to the Views node in your schema.

If the view you want to display is in another user's schema, navigate to the Other Users node, expand it, find the name of the schema the view is in, and navigate to the Views node. Examples of schema names include SYS and HR.

Open the Views node. The list of views in the schema appears.

Click the name of the view that you want to display. A tab with the view name appears in the object pane, with the Columns subtab displayed. You can view the view definition on this tab.

How to set Profile Attribute in Siebel Workflow

For setting the Profile Attribute in Siebel Workflow, follow below steps: Add Business Service box in workflow. Open Business Service properties. Set SessionAccessService in Business Service Name. Set SetProfileAttr in Method Name. Then click on Business Service and set Input Arguments as below: Against Name argument you will add your profile attribute name and against Value argument you will add value for the new profile attribute, it could be from Process Property or Literal.

How to call Popup Applet through Server Script in Siebel

Below is the script for calling popup applet through script: if (MethodName == "MethodName") { var oServiceAF = TheApplication().GetService("SLM Save List Service"); var inputPropAF = TheApplication().NewPropertySet(); var outputPropAF = TheApplication().NewPropertySet(); inputPropAF.SetProperty("Applet Name","ABC Popup Applet"); inputPropAF.SetProperty("Applet Mode","6"); inputPropAF.SetProperty("Applet Height", "700"); inputPropAF.SetProperty("Applet Width", "700"); oServiceAF.InvokeMethod("LoadPopupApplet", inputPropAF, outputPropAF) return (CancelOperation); } Applet Modes: 1=Base, 2=New, 3=Edit, 5=Query, 6=EditList

How to query or find record in Siebel Business Component

You can perform query operation on Business Component through Workflow, eScript with the help of Siebel Operation, Inbound E-mail Database Operations (method: FindRecord) or EAI Siebel Adapter (method: Query but you need to create Integration Objects). This Business Component can be Virtual Business Component (VBC), External Business Component (EBC) or generic Business Component (BC). See also: Difference Between Business Components and How to Create BC in Siebel through Object Wizard through Workflow with the help of Siebel Operation Create a workflow and provide the Business Object, business component should be in this BO for which you want to perform the query operation. From the Palettes window drag drop the Siebel Operation into workflow designer plane. Select the Siebel Operation box and open the properties window, provide the Business Component name from the drop down list and set Query in Operation field. You can set the search specification by two means either provide the fie

ITCanopy

Search This Blog