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.

What is left join example?

1007

---

What is %type in pl sql?

1006

---

What are the different set operators available in sql?

1076

---

What is mutating error in pl sql?

1061

---

what is data control language? : Sql dba

1065

---

What is db journal file?

1150

---

How to find 3rd highest salary of an employee from the employee table in sql?

1129

---

what are the disadvantages of mysql? : Sql dba

1205

---

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

1129

---

How can we avoid duplicating records in a query?

1031

---

How is use pl and sql?

1105

---

How do I save the results of sql query in a file?

1010

---

what are the advantages and disadvantages of views in a database? : Sql dba

1069

---

when is the use of update_statistics command? : Sql dba

1095

---

who introduced sql?

1069

---