Answer / kalyan kumar

The unique value generated bydefault for each and every row
in the column of any table when user inserts records.

Answer / aasid

A rowid is a pseudo column (like versions_xid), that
uniquely identifies a row within a table, but not within a
database. It is possible for two rows of two different
tables stored in the same cluster to have the same rowid.

Answer / rajesh

ROWID
Every record has a unique ROWID within a database
representing the physical location on disk where the record
lives. Note that ROWID's will change when you reorganize or
export/import a table.

Answer / guest

ROWID Represents phyiscal location on disk for a record.It
is unique Hexadecimal number (like AAAL+ZAAEAAA....)which
get generated automatically at the time of insertion.

Answer / srikanth

It gives the location in the database where row is
physically stored.

Answer / akash lekurwale

row id is the address for each row when it will insert into
the table it is unique even some rows are inserting
duplicate

Answer / sourisengupta

ROW_ID is a pseudo column in each table. This column is
appended by default to every table that is created.You can
dentify each row by this column.

Answer / jigar r gor

ROWID is a pseudo column that oracle derives for each record fetched by an implicit SQL query.
Every rowid associated to the data row of a table is dynamically assigned and is not part of the actual user table.
Also the same can be just referred and not be used as sequences.

Is it possible to update views?

0 Answers  

What is a pl/sql block?

0 Answers  

Are views faster than queries?

0 Answers  

What is db journal file?

0 Answers  

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

How many rows can sqlite handle?

0 Answers  

define different types of trigger. : Sql dba

1 Answers  

What is nosql db?

0 Answers  

How to access the current value and next value from a sequence?

6 Answers  

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

Is sql considered coding?

0 Answers