Answer / yuvaevergreen

dynamic sql is invoking SQL inside a stored procedure during
run time. execute immediate or call can be used to invoke
dynamic sql.

How can you track login parameters of users in teradata?

0 Answers  

---

i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80

12 Answers   CTS,

---

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

0 Answers  

---

I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

4 Answers   Cap Gemini,

---

Explain the term 'columns' related to relational database management system?

0 Answers  

---

What is meant by a Highest Cost Plan?

0 Answers  

---

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

9 Answers   IBM,

---

in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that

1 Answers   IBM,

---

Explain the term 'database' related to relational database management system?

0 Answers  

---

what is identity columns in teradata

2 Answers   Wipro,

---

How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.

2 Answers  

---

What are the functions performed by bynet?

0 Answers  

---