Answer Posted / shanmugavelu

suppose u have create partition table like,

Sql>Create table Pixel_emp_details(emp_no number,
emp_name varchar2(10))
partition by range (emp_no)
(partition pixel_p1 values less than(10));
Sql>/
Table is created

After that u have use normal insert statement like

Sql> insert into pixel_emp_details partition(pixel_p1)
values(1,'gopi')
SQL> /

1 row created.

What is a snapshot in oracle database?

1070

---

How to convert numbers to characters in oracle?

1077

---

What is pragma autonomous transaction in oracle?

1121

---

How to start a new transaction in oracle?

1134

---

How to use subqueries in the from clause in oracle?

1165

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3096

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1746

---

How to connect ms access to oracle servers?

1056

---

What is a select query statement in oracle?

1024

---

How do I manually create a database in oracle?

1067

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

2007

---

How to handle a single quote in oracle sql?

1096

---

What is a system tablespace and when it is created?

1012

---

Explain self joins in oracle?

1056

---

When system tablespace is created?

1087

---