Answer Posted / chakri

Hi friend,

In the above Select statement 1 is constant so it will
display with respect to the other columns infromation

Result for ur query:

column_heading no_col col2_2 col3_3

1 name1 3000
1 name2 2000

in this way it will display the result.

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1080

---

explain about mysql and its features. : Sql dba

1021

---

Why do you partition data?

1028

---

what is not null constraint? : Sql dba

1039

---

List out the acid properties and explain?

966

---

Explain raise_application_error.

1105

---

What are tables in sql?

1071

---

What plvcmt and plvrb does in pl/sql?

1328

---

What is the difference between functions, procedures, and packages in pl/sql?

1057

---

what is a trigger in mysql? Define different types of trigger. : Sql dba

1073

---

what are string data types? : Sql dba

1049

---

Which table is left in join?

983

---

How long it takes to learn pl sql?

1021

---

What is the difference between an inner join and an outer join?

1029

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1078

---