How to get unique records from a table?

0 Answers  

---

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

---

Why do we go for stored procedures?

0 Answers  

---

What is rule base and cost base optimizer?

2 Answers   Thermotech,

---

how can i create a user defined datatype

3 Answers  

---

What is sql profiler in oracle?

0 Answers  

---

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  

---

Mention what pl/sql package consists of?

0 Answers  

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

What is meant by temporal data?

0 Answers  

---

what is an alias command? : Sql dba

0 Answers  

---

What is data profiling in sql?

0 Answers  

---