Question { 15497 }

Is it possible to use LONG columns in WHERE clause or ORDER
BY?

Answer

Long data type can't participate for any operation in SQL.

Only DML queries can be applied.

Can't apply any aggregate function on LONG colum.

Can't apply any analytical function on LONG colum.

Can apply sequence on LONG colum.

Can apply synonym for LONG column table.

Can create view for LONG column table and Mat view is not possible.

Question { Oracle, 11689 }

What are the security level used in BO?

Answer

Can anyone explain the diff between the following each.

Public
controlled
restricted
confidential
private

Question { Accenture, 21202 }

will function return more than one value how

Answer

Can someone give an answer with good example for this question.

Question { 5780 }

how to create a database in oracle?

Answer

Give some diff answer Lavakush. Dont copy the same...

Question { CTS, 13511 }

How do u count no of rows in a table?

Answer

There are 2 ways used to find the row count of any table.

SELECT COUNT(*) FROM EMP;

SELECT TABLE_NAME, NUM_ROWS FROM USER_TABLES WHERE TABLE_NAME='EMP';

Question { JDA, 19476 }

What is difference between select statement and cursor

Answer

The above answer is not so correct.

cursor can fetch rowid, rownum also from table.

The select into cant retrieve more than 1 record in plsql.

But cursor can retrieve more records that can be viewed for modified later in plsql.

Cursors has attributes like open,close,fetch,notfound. Those attributes not applicable in select..into clause.

finally select..into in plsql, just select column values and storing into plsql variable.

Question { Perot Systems, 9268 }

How to restrict the user to refresh or Run the report only
1 time in BO?

Answer

Till now noone has given the direct and correct answer for this question.

After the above answers, did anyone get the answer what I asked.

Question { Perot Systems, 9268 }

How to restrict the user to refresh or Run the report only
1 time in BO?

Answer

I think all r not correct answer.