Oracle Database

supermarket (ER-Diagram)

The question is a bit short but I cured a locking problem with the following if it helps?

-- MESSAGE "Data" OR "Information" "is out of date" on some APP screens.

--

-- Identify which table is affected. In this case we know that

-- ops are stored in table WTL. We now need a session_id and serial number

-- so we can invoke the kill command against this rogue process.

--

-- sqlplus system/password@schemaname

select object_id from dba_objects where object_name ='WTL';

--3738

--3820

--3930

--3335

--

-- The following was run against 3738, 3820 and 3930 but nothing was returned

-- However when run against 3335 returned a session_id of 71

select * from v$locked_object where object_id=3335;

-- All we need now is the serial number so we can kill the rogue process.

--

select sid, serial#, command, taddr from v$session where sid=71;

--

-- This returned us a serial number 16711

--

-- All the above can be combined as below:

--

select sid, serial#, command, taddr

from v$session

where sid=(select SESSION_ID

from v$locked_object

where object_id in (select object_id

from dba_objects

where object_name='WTL'))

-- If we are sure this is the rogue lock then kill it.

alter system kill session '71,16711';

-- If it refuses to die use

alter system kill session '71,16711' IMMEDIATE ;

--

-- NOTE: Your sid and serial number will be different from this example!

-- NOTE: Closing the APP window and waiting 10 minutes can (sometimes) also cure the fault.

Enterprise Business Suite

There s 8 reasons on why you should use double slash in oracle. The reasons are easy connect, local naming, directory naming, default context, entries, files and external.

Introduction to DQL -Documentum Query Language-

The language used to query Documentum which is a content management

system used to create, manage, deliver, and archive all types of content from text documents and spreadsheets to digital images, HTML, and XML components.

Contents

• Define DQL

• Behind the scenes

• Describe a SELECT statement

• Describe how search conditions are specified in a WHERE clause

• Using DQL to search a specific cabinet/folder location

• Describe the DQL REGISTER statement

DQL (Documentum Query Language) is a query language which allows you to do very complex queries involving:

1. Property searches

2. Searches for words and phrases within documents

3. Other specialized searching capabilities added for document and content management

DQL uses syntax that is a superset of ANSI-standard SQL (Structured Query Language)

• In fact, part of your DQL statements are translated automatically into SQL before being executed by the eContent Server

Behind the Scenes

• A DQL query is sent to the eContent Server using one of four API methods

readquery, execquery, query, or cachequery

• A DQL engine on eContent Server generates

- SQL queries for the RDBMS

- Verity queries for the full-text search engine

The results of the query are stored on the server in a non-persistent collection

object. Typically, a Documentum client will automatically present the results

of the query to the user in some useful way.

Alternatively, a Developer may want to use the resulting collection object or

manipulate the results programmatically.

Basic Select Statement

Select (list the properties you want returned)

From (list the type of objects you want searched)

Using WHERE clause

Allows the search to be narrowed by imposing search conditions on your

Query

select [all | distinct] value [as name] {, value [as name] } from source_list[(all)]

...

[where qualification ]

Eg :

SELECT object_name, title FROM dm_document WHERE FOLDER (ID('0b9af3ce800001ff')) AND title LIKE '%SOP%'

Searching folders and cabinets

The scope of the search can be specified as folder and cabinet in the where clause to provide a way to search the cabinet/folder hierarchy.

Eg : select object_name from dm_document where folder('/Sales')

REGISTER statement

• Registers an RDBMS table so the eContent Server can "see" it

• Allows access to data in an existing RDBMS table that may be

- created to support additional application data

- part of another application

- owned by someone else

• Does not verify that the table or its columns exist

• All columns in a table need not be registered

• Creates a dm_registered object in the System cabinet which

provides a description of the table and user access to it

REGISTER permissions

• Only the Docbase owner with a SUPERUSER privilege can register a table from

within Documentum.

• To register a table, you must have at least READ permission on the table (through the

RDBMS grant command).

• The eContent Server account (installation owner) needs the appropriate RDBMS

privileges on the table to perform different operations on rows in the table.

3200 ft.

Query String is used to send the values from one webpage to other page.

The format of query string as follows

http://www.xyz.com/address.html?name=james %20 address=uk

The above query string sends the value name=james and address=uk to the address.html page.

The advantages of indexes in Oracle are that it is faster at accessing rows and is useful. The disadvantages are that the table used is small and an index must be used in order to access data.

Internet capable.

An oracle is generally the person that gives a prophecy.

The full name for the acronym ANSI is the American National Standards Institute. It is a private non-profit organization that oversees the development of voluntary consensus standards for products, services, processes, and systems in the United States. ANSI also represents the U.S. in international standards organizations and promotes the use of standards to enhance global competitiveness.

malach mahit nahi malach sanga......

An external constraint is something outside a business that stops the business achieving it's aims and objectives. For example, changing consumer's tastes.

If you are going to use the date column in the WHERE clause of you select, THEN Indexing on that date column will enhance the performance Hope this helps

Jocasta believed that prophets are not Gods and can make mistakes. She believes no human has the skill to be prophets.

ALTER TABLE mytab MODIFY (mycol <modifications>)

A NULL in C is a pointer with 0 value, which cannot be a valid address.

A null in Oracle is the condition of not having a value, such as a field in a row being null, meaning that it does not have a value. This is not the same as zero - zero and null are two different things.

Note, however, that Oracle does not differentiate between a null and a zero length string. This was an error in non-ANSI implementation made many years ago, but it has persisted because fixing it would impact too much "running" code.

Item Category is grouping of items. Item Category Sets is grouping of Item Categories. An item can belong to any number of category sets. We can assign item to one category within each category set. The categories can be retrieved from the table 'mtl_categories_b' and item category set from 'mtl_category_sets_b'. The list of categories for a category set are the categories with the same flexfield structure as the category set.

Actually there are several different Yes / No Oracle sites available online. Some examples include "The-Oracle-Answers", "Facade" (select "Yes or No" from the menu) or "Yes No Oracle" from VIP Tarot.

Each database lists the hardware requirements in their install guide.

The default date format can be set at the database level. The default in the USA is:

DD-MON-YYYY

e.g. 01-JAN-2012

This format will also accept a lowercase month name, such as 01-jan-2012.

Best practice is to always provide an explicit date format for any conversion:

l_date_string VARCHAR2(16) := TO_CHAR(SYSDATE, 'DD-MON-YYYY');