Sql technical questions

0 Answers  

---

How to find last day of the month in sql query

4 Answers  

---

How to test for null values?

0 Answers  

---

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,

---

Is a foreign key always unique?

0 Answers  

---

What is the difference between left join and right join?

0 Answers  

---

What is varchar example?

0 Answers  

---

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

0 Answers  

---

What is trigger and stored procedure in sql?

0 Answers  

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

---