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 the difference between $message and $$message? : Sql dba

995

---

what is a materialized view? : Sql dba

1059

---

How much does sql cost?

994

---

What is the example of procedure?

926

---

What is a native sql query?

1062

---

Why stored procedure is better than query?

941

---

how to return query output in html format? : Sql dba

1073

---

How do you create a db file?

1011

---

What does the argument [or replace] do?

1074

---

What is function and procedure in pl sql?

1037

---

what are all different types of collation sensitivity? : Sql dba

979

---

Is left join faster than join?

1045

---

How does postgresql compare to oracle/db2/ms sql server/informix?

1032

---

What are the different types of functions in sql?

1048

---

Name some usages of database trigger?

1016

---