Answer Posted / abc

SELECT * from empl WHERE ROWID IN (
SELECT MAX(ROWID) FROM empl
UNION
SELECT MIN(ROWID) FROM empl
);

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2047

---

Can multiple columns be used in group by in oracle?

930

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2153

---

Is a rollback possible to any savepoint?

1001

---

How to enter a new row into a table interactively?

963

---

What are the different types of record groups in oracle? Explain each of them

972

---

What is system tablespace?

1044

---

How to use "in" parameter properly?

1006

---

why dont we assign not null constraint as table level constraint.

2685

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2134

---

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'));

1617

---

Explain oracle instance.

1107

---

Is oracle a relational database?

871

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2902

---

How to assign a table row to a record variable?

969

---