Answer Posted / priya

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

Which table is left in join?

957

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1180

---

Explain the structure of pl/sql in brief.

1067

---

What is procedure and function?

959

---

what are ddl statements in mysql? : Sql dba

1173

---

Is keyword pl sql?

960

---

What do you think about pl/sql?

1000

---

Do ddl statements need commit?

957

---

Define join and name different types of joins?

987

---

what is sp_pkeys? : Transact sql

1138

---

What is sql not null constraint?

1008

---

How do you go back in sql?

973

---

Can we insert in view in sql?

1036

---

What are the possible values that can be stored in a boolean data field?

984

---

What are triggers and its types?

1041

---