Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

Why do we use procedures in pl sql?

0 Answers  

---

What is trigger in sql and its types?

0 Answers  

---

How to return multiple records from procedure?

2 Answers  

---

What is trigger in sql?

0 Answers  

---

What are sql*plus environment variables?

0 Answers  

---

what is the difference between cluster and non cluster index? : Sql dba

0 Answers  

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

0 Answers  

---

What is forward declaration in pl sql?

0 Answers  

---

How do we tune the code?

2 Answers  

---

hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance

1 Answers  

---