Mohammed Abdul Afroze

• Sep 27th, 2007

Schema Belongs to the objects are as follows:Sql>Desc dba_objects

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Sep 26th, 2007

It can be some application interacting the oracle as a server/database. Forms, Toad etc.

Answer Question  Select Best Answer

G. Sreedhar

• Sep 26th, 2007

Actually there are several ways of importing the data from Excel files to Oracle database.1) Save the .xls file to .csv file and then by using TXT2SQL tool we can generate the code and execute the code in TOAD or SQL prompt.2) By using SQL*LOADER we can import the data from excel to oracle database.

Answer Question  Select Best Answer

laxmidhar

• Sep 5th, 2007

When a prepare statement got executed the statement will be executed through the parser. The parer will check the all syntax. Then it will go to the database. If any wrong was found on the statement then it will return error message..

Answer Question  Select Best Answer

Connect as sydba Write a LOGON trigger like this     CREATE OR REPLACE TRIGGER RESTRICT_TOOL AFTER LOGON ON DATABASEDECLARE   L_TOOL  V$SESSION.PROGRAM%TYPE;BEGIN SELECT PROGRAM INTO L_TOOL FROM V$SESSION WHERE  AUDSID = USERENV('SESSIONID')   AND  AUDSID != (SELECT AUDSID                   FROM V$SESSION                   WHERE USERNAME='SYS'); IF UPPER(L_TOOL) LIKE '%TOAD%' OR UPPER(L_TOOL) LIKE...

Laxmi Kant Sharma

• Aug 30th, 2007

This solution is not working properly.. because it is not raised after logon. so there is no use of raise_application_error after login. Is there any other method for that?

Dinesh G

• Aug 6th, 2005

Above shown trigger won't work if user system. Same will happen if any use opts the as sysdba option.  Is there any way to close these loop holes ?

Answer Question  Select Best Answer

Innila

 Profile Answers by Innila Questions by Innila

• Aug 13th, 2007

Hi rajapantula,Do u mean 'concatenate 2 columns' ?*** Innila ***

Answer Question  Select Best Answer

Rajesh S

• Aug 10th, 2007

This option provides a high level of integrity (WRITE inegrity) for data being updated, while providing no special protection for data only being read. Many tasks in several VSE images can open the ...

Answer Question  Select Best Answer

sanjeev

• Aug 6th, 2007

In session properties we have the target commit interval. There we need to mention the commit interval as 1000.Sanjeev

Rajesh

• Oct 10th, 2006

Yes, we have different logic to accomplish this thing in Informatica. You use either sequence generator and Filter transformation or Expresion and Fileter transformation. If you are sorting and loadin...

Answer Question  Select Best Answer

padmanabham

• Jul 28th, 2007

Non primary column direclty depended on the primarykey column is called a 3rd narmalization form

rajesh

• Oct 17th, 2005

In order to be in Third Normal Form, a relation must first fulfill the requirements to be in Second Normal Form. Additionally, all attributes that are not dependent upon the primary key must be eliminated.

Answer Question  Select Best Answer

A  property clause is a named object that contains a list of properties and their settings. Once you create a property clause you can base other object on  it.  An  object  based  on  a  property  can inherit the setting of any property in the clause that makes sense for that object.

fastfreeeasy

 Profile Answers by fastfreeeasy Questions by fastfreeeasy

• Jul 26th, 2007

If you are talking about Developer/2000 then this is not Property Clause rather Property Class. One more thing is that change of visual attribute of an item is possible programatically but the same is...

Answer Question  Select Best Answer