I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

four procedures is are there should i write their in a package

2 Answers  

---

Are sql connections encrypted?

0 Answers  

---

Which sorts rows in sql?

0 Answers  

---

Which is better join or inner query?

0 Answers  

---

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

What are the types of sql commands?

0 Answers  

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

0 Answers  

---

what is julian date in oracle

2 Answers  

---

Are pl sql variables case sensitive?

0 Answers  

---

What is delete command in sql?

0 Answers  

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---