Answer Posted / priya

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

How many commands are in sql?

1118

---

How do I write a cron which will run a sql query and mail the results to agroup?

1029

---

What is AUTH_ID and AUTH_USER in pl/sql ?

2233

---

Can we use two order by clause in query?

1015

---

What is the difference between inner join and natural join?

1055

---

How does sql profiler work?

1065

---

What is a left inner join?

1068

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

1016

---

What is materialized view in sql?

958

---

What are schema-level triggers?

1151

---

What is the difference between clustered and non-clustered index in sql?

1065

---

What is oracle sql called?

972

---

What is sql in oracle?

1108

---

What is embedded sql with example?

1097

---

What is a primary key sql?

1093

---