Answer / Amla Rani

In SQL and PL/SQL, a record is a user-defined collection of related data items. Each record has a name and consists of one or more fields (or attributes). Records can be considered as a table with only one row. An example of creating a record in SQL would be: CREATE OR REPLACE TYPE Employee_Record AS OBJECT (id NUMBER, name VARCHAR2(50), salary NUMBER);

How do I pipe the output of one isql to another?

1 Answers  

---

What is the difference between database trigger and stored procedure?

1 Answers  

---

What are pl sql data types?

1 Answers  

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

Can we insert in view in sql?

1 Answers  

---

Are stored procedures faster than dynamic sql?

1 Answers  

---

What is schema in sql example?

1 Answers  

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1 Answers  

---

How delete all data from all tables in sql?

1 Answers  

---

Why we use joins in sql?

1 Answers  

---

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

---

Can we commit in trigger?

1 Answers  

---