How to read columns from excel file (converted into *.CSV format) into Forms using upload button.

kishore.harname

 Profile Answers by kishore.harname Questions by kishore.harname

• Oct 31st, 2009

You can use UTL_file package which is provide by Oracle to read & write data into csv file or use external table funda.

Answer Question  Select Best Answer

What is the role of Referential Integrity Constraint in Normalization?

surendra

• Jan 31st, 2013

Best examples of Referential Integrity constants Primary Key And Foreign key. Primary Key constraint allow a particular attribute to be not null and unique. Where as Foreign key will be used when ever there is a need to maintain the same attribute values in the multiple tables.

Answer Question  Select Best Answer

When do we will go for Sequence and when go for Indexes. What is the difference between Sequence and Indexes.

varunprasath

 Profile Answers by varunprasath Questions by varunprasath

• Jun 7th, 2010

Sequence - A sequence is used to generate a number sequence that can be used as a primary key.Indexes - An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns.

Answer Question  Select Best Answer

Explain about the Chained / Migrated Rows

vidyajnath

 Profile Answers by vidyajnath Questions by vidyajnath

• Apr 23rd, 2010

In two circumstances, the data for a row in a table may be too large to fit into a single data block. In the first case, called chaining, the row is too large to fit into an empty data block. In this ...

Answer Question  Select Best Answer

Outline the names and function of Oracle background processes

vidyajnath

 Profile Answers by vidyajnath Questions by vidyajnath

• Apr 23rd, 2010

The Oracle architecture has five mandatory background processes Mandatory background processes: DBWR (Database Writer) PMON (Process Monitor) CKPT (Check Point) LGWR (Log Writer) SMON (System Monitor)...

Answer Question  Select Best Answer

How can you prevent tablespace fragmentation? (rebuilding, moving)?

vidyajnath

 Profile Answers by vidyajnath Questions by vidyajnath

• Apr 23rd, 2010

As rows are added to tables, the table expands into unused space within the space. Conversely, when rows are deleted, a table may coalesce extents, releasing unused space back into the tablespace. As ...

Answer Question  Select Best Answer

How to see materialized view occupied memory space?

PK

• Feb 29th, 2012

There is a data dictionary called as ALL_MVIEWS.
You can check the query and the length of the query in this data dictionary as

Select * from ALL_MVIEWS where MVIEW_NAME = MVIEWNAME

Answer Question  Select Best Answer

What is log switch?

asit

• Jun 9th, 2012

log switch ::suppose we have two redo log files LOG A, LOG B. when transaction(DML) are occurred in Database then they are recorded in LOG A. When LOG A is filled up, a log switch occurs, All new tran...

Answer Question  Select Best Answer

How to show the cursor is busy when any process is going on in Oracle Forms 6i?

budzboy

 Profile Answers by budzboy Questions by budzboy

• Jul 14th, 2010

Set_application_property(cursor_style, busy);

Answer Question  Select Best Answer

Which one will give best performance between GROUP BY function in Oracle and GROUP BY function in Crystal Reports? Explain

Shyam

• Oct 22nd, 2015

The Group BY in Oracle will give best performance, because Group By is not a function for Oracle.

Answer Question  Select Best Answer

How to join two columns which is having different datatype? Say Coulmn1 with Varchar2 datatype and Coulmn2 with long datatype.

PK

• Feb 28th, 2012

You can join the columns with two different data types by using to_char, to_number to_date functions.
For e.g. one field is a varchar which stores number and other field is a number then you can use.
to_number(var_column) = number_column

Answer Question  Select Best Answer

What do you mean by ROW_NUMBER(), RANK(), DENSE_RANK() differentiate them?

asit

• Jun 9th, 2012

THE BELOW FUNCTIONS ARE OLAP FUNCTIONS...

rank() function skips the continuity but dense_rank() function gives the sequence.It is always advised to use dense_rank for viewing nth highest/lowest value. row_num() gives the serial no in the order how they are inserted in to a table.

Answer Question  Select Best Answer

Which system tables contain information on privileges granted & privileges obtained?

asit

• Jun 9th, 2012

For users permissions : user_tab_privs table is used.
for viewing all permissions : all_tab_privs

Answer Question  Select Best Answer

What do you mean by Force View?

asit

• Jun 9th, 2012

Force view is the process to create a view forcefully without a base table. syntax:

Code
 

Answer Question  Select Best Answer

Explain the concept of compond triggers

neeraj06.in

 Profile Answers by neeraj06.in Questions by neeraj06.in

• Nov 10th, 2011

Compound Triggers: -> It combines all DML timing events into single trigger body. -> It also resolves mutating table error and enhance the code maintenance. -> The memory variables are persistent t...

Answer Question  Select Best Answer

How to convert Oracle Report into text or doc file?

bondneoo

 Profile Answers by bondneoo Questions by bondneoo

• Aug 18th, 2010

Goto Tools->Preferencesthen Runtime Values->Set mode to character.

Answer Question  Select Best Answer

What is an exception in Oracle?

asit

• Jun 9th, 2012

Exceptions are nothing but the errors occurred at the run time. To handle the exception we use exception block in the PLSQL.

Answer Question  Select Best Answer

What is an Archiver in Oracle?

venkatesh

• Jun 8th, 2012

Its background processes in oracle, it will write offline redolog group information into archive log files

Answer Question  Select Best Answer

dynamic cursors are used in airline reservation system as changes made must be reflected in result set as most updated information is required for booking.
can anyone tell me the exact use of static cursor where most update changes are not required? in which application system it is useful?

vannalas

 Profile Answers by vannalas Questions by vannalas

• Nov 11th, 2011

Hi,

Can you give the examples of static and dynamic cursor ?
I will answer your question.

Answer Question  Select Best Answer

Neer.ocp10g

 Profile Answers by Neer.ocp10g Questions by Neer.ocp10g

• Jan 21st, 2012

The SCN is an important quantifier that oracle uses to keep track of its state at any given point in time. The SCN is used to keep track of all changes within the database, its a logical timestamp tha...

Answer Question  Select Best Answer