Answer / 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 do you understand by database schema and what does it hold?

0 Answers  

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

Do View contain Data ?

10 Answers  

---

what is the difference between substr and instr function in oracle?

0 Answers  

---

Does rowid change in oracle?

1 Answers  

---

what is RAID technology?which is better RAID 0+1 OR RAID 5?

2 Answers   CSC,

---

What is Private Database Link ?

1 Answers  

---

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

0 Answers  

---

List out the components of logical database structure of oracle database.

0 Answers  

---

How to write a query with a right outer join in oracle?

0 Answers  

---

Please explain joins in oracle?

0 Answers  

---

Why cursor variables are easier to use than cursors?

0 Answers  

---