Answer / s

A.HASH partitioning is useful on columns which are unique
in nature where range or list partitioning cannot be done.
All the hash partitions hold an equal number of rows
thereby improving the performance and response time of the
query if the table is queried.

List partition is used on a table if you can divide table
based on column value. Something like region wise
partioning if the table contains a column like region.The
advantage of list partitioning is that you can group and
organize unordered and unrelated sets of data in a natural
way.

How can u find column name from a table which have max value in a row.( not max value)

5 Answers  

---

What is the advantage of index in sql?

0 Answers  

---

what are the advantages of cursors than procedures?

2 Answers  

---

how to see the create table statement of an existing table? : Sql dba

0 Answers  

---

How do you explain an index?

0 Answers  

---

How do I count records in sql?

0 Answers  

---

How to install oracle sql developer?

0 Answers  

---

Show code of a cursor for loop.

0 Answers  

---

Explain the purpose of %type and %rowtype data types?

0 Answers  

---

what is self join and what is the requirement of self join? : Sql dba

0 Answers  

---

what is heap table? : Sql dba

0 Answers  

---

Hi All, I am new to both this blog and technology. I was able to see a response for one of the questions on triggers as below. I would like to know why are we using " if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then" instead, can't we use " if sysdate = 'sunday' then". I can understand the use of "rtrim", but dont know y v r using to_char. I have seen this in many cases but did not get a convincible explaination. Please help me with this and do excuse if this question sounds silly. Thanks in advance...... create or replace trigger trg_sun before insert on <table name> begin if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then raise_application_error(-20345,'no transaction in sunday'); end if; end trg_sun;

2 Answers  

---