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

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

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

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

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

Mohammed Abdul Afroze

• Sep 27th, 2007

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

Answer Question  Select Best Answer

Mohammed Abdul Afroze

• Sep 27th, 2007

If a users is having the SYSDBA Privilege then he can be able to accesses the data dictionary views.

Chiranjeevi Manne

• Mar 30th, 2007

If scott has the privilege of "SELECT ANY DICTIONARY", then he could read the information in DICTIONARY views.

Answer Question  Select Best Answer

Mohammed Sameer

• Nov 27th, 2007

Dude Remember!when its your first job you should say"It doesnt matter if you pay me less or more i believe with my good work I would get a handsome salary today or tomorrow and I am sure organisation ...

Gururaj

• Nov 30th, 2006

Well,It depends upon your company policies.I liked this figure 10000 so i demanded if ur company wants to pay more u r welcomed.and it depends on year exp.if ur exp then alwaz ask >  30% hike

Answer Question  Select Best Answer

madhupriya

• Nov 27th, 2007

Normalization is being applied for the database to reduce redundancy as in case of first normal for remove the redundant data from rows and in 2nd normal form it removes the redundant data vertically ...

Answer Question  Select Best Answer

sreekumar_nair_it

 Profile Answers by sreekumar_nair_it Questions by sreekumar_nair_it

• Dec 1st, 2007

Try thisCREATE OR REPLACE FUNCTION FIN2008.rowtocol( p_slct IN VARCHAR2,p_dlmtr IN VARCHAR2 DEFAULT ',' ) RETURN VARCHAR2AUTHID CURRENT_USER ASTYPE c_refcur IS REF CURSOR;lc_str VARCHAR2(4000)...

ora.nachs

 Profile Answers by ora.nachs Questions by ora.nachs

• Feb 5th, 2007

we can also do this by insert all statement.....INSERT ALLINTO sales_info VALUES (employee_id,week_id,sales_MON)INTO sales_info VALUES (employee_id,week_id,sales_TUE)INTO sales_info VALUES (employee_i...

Answer Question  Select Best Answer

amisha_me

 Profile Answers by amisha_me Questions by amisha_me

• Dec 27th, 2007

Only the size differs in nvarchar2 length is much more compare to varchar2

Answer Question  Select Best Answer

How can I copy a table from one database instance to another database instance

napster.syed

 Profile Answers by napster.syed Questions by napster.syed

• Feb 27th, 2008

By using Db link

Answer Question  Select Best Answer

How to migrate db2 data to notepad?

swaroopbns

 Profile Answers by swaroopbns Questions by swaroopbns

• Apr 30th, 2008

Do you mean that you want to unlaod a db2 table into a notepad or textpad, then you can probably try this:db2> export to yourdirectory/abc.txt of del select * from tablename with ur

Answer Question  Select Best Answer

kmuddana

 Profile Answers by kmuddana Questions by kmuddana

• Apr 30th, 2008

Select top1 * from in SQL Server

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 12th, 2007

SELECT * FROM EMPLOYEES WHERE ROWNUM=1; IN ORACLE

Answer Question  Select Best Answer

Why do we need a DDL and DML in a database system?

laikka_buddy

 Profile Answers by laikka_buddy Questions by laikka_buddy

• May 5th, 2008

DDL  is  nothing   but   Data  Definition  Language .  It is very important for a  dadabase that we have to  define  the data   such that  we can  create tables , alter tables, truncate  and  drop  tables

ugly1

 Profile Answers by ugly1 Questions by ugly1

• Jan 25th, 2008

DDL stands for data definition language and DML stands for data manipulation language.DML changes data in an object (eg-insert,update,delete) and when we create,change or remove a database object thats DML (eg-create). so both are important.

Answer Question  Select Best Answer

Kandeepan

 Profile Answers by Kandeepan Questions by Kandeepan

• Jun 4th, 2008

How many days, we are going to retain the data after taking the backup.  For example the data which backed up today that will get expire in 90 days. That means, it is 90 days retention policy for backup

Mohammed Abdul Afroze

• Oct 30th, 2007

You can configure retention policy command to create a persistent and automatic backup retention policy.When a backup retention policy is in effect, RMAN considers backups of datafiles and control fil...

Answer Question  Select Best Answer

nandk.sharma

 Profile Answers by nandk.sharma Questions by nandk.sharma

• Jun 16th, 2008

nvl2 function is the upgraded form of nvl function.In nvl function we need to pass two parameters.i.e. nvl(interest_rate ,returned_value) if the value of interest_rate is null then the nvl function r...

thumunagamani

 Profile Answers by thumunagamani Questions by thumunagamani

• Jun 13th, 2008

Nvl2(exp1,exp2,exp3)if exp1 is null it manipulate exp3,if exp1 is not null it manipulates exp2eg:select ename,nvl2(comm,comm+sal,sal) net from emp;

Answer Question  Select Best Answer

What is the difference between Case and Decode?In what situation we can use Case and Decode

veerisetty

 Profile Answers by veerisetty Questions by veerisetty

• Jun 18th, 2008

DECODE works with expressions which are scalar values.CASE can work with predicates and subqueries in searchable form:CASE is an ANSI standard, where as Decode is proprietary for OracleWe can use expressions as part of case statements, where as Decode looks for a value.regardsveerisetty

Answer Question  Select Best Answer

sweetytrivedi

 Profile Answers by sweetytrivedi Questions by sweetytrivedi

• Jun 25th, 2008

B-Tree indexes are usually associated with the index that stores a list of ROWIDs for each key.While Bitmap is also organized as B tree , but the leaf node stores a bitmap for each value instead of a list of ROWIDs. B tree can be used for OLTP while bitmap is used for data warehousing system.

hemshikha

• Sep 1st, 2006

Conventional wisdom holds that bitmap indexes are most appropriate for columns having low distinct values?such as GENDER, MARITAL_STATUS, and RELATION. This assumption is not completely accurate, howe...

Answer Question  Select Best Answer

Which one is strongest normal form? Why?

kumaranvp

 Profile Answers by kumaranvp Questions by kumaranvp

• Jul 12th, 2008

Boyce codd normal form is the strongest normal form.........

Answer Question  Select Best Answer