Answer / ayan banerjee

create type type_name as object
()

Answer / priya

create type type_name as object
(
No NUMBER,
Name Varchar2(15),
City VARCHAR2(30,
POSTALCODE CHAR()
);

What is scalar and vector?

1 Answers  

---

Can we create view in stored procedure?

1 Answers  

---

Explain the uses of control file.

1 Answers  

---

Talk about views

10 Answers   Polaris,

---

What normalization means?

1 Answers  

---

What is a stored procedure in sql with example?

1 Answers  

---

Explain what is sql?

1 Answers  

---

How to get list of all tables from a database?

1 Answers  

---

what are the advantages of package?

7 Answers   iFlex,

---

How to use distinct and count in sql query? Explain

1 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

what is a constraint? Tell me about its various levels. : Sql dba

1 Answers  

---