Answer / Alok Shukla

To allow a user to connect to an Oracle database server, the user needs to be granted the CONNECT role. This can be done with the following SQL command:

```sql
ALTER USER username GRANT CONNECT;
```

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

1 Answers  

---

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

1 Answers  

---

How to set up autotrace for a user account?

1 Answers  

---

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

3 Answers   HCL,

---

What is snapshot is too old? Give and example for better understand.

1 Answers   TCS,

---

What is different types of joins?

1 Answers  

---

How do we display rows from the table without duplicates?

1 Answers  

---

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  

---

Shall I get Pro*C Compiler in Oracle-10g release ?

1 Answers  

---

select trunc(round(156.00,-1),-1) from dual;

2 Answers  

---

What are the types of trigger in oracle?

1 Answers  

---

What is an anonymous block?

1 Answers  

---