Answer / amrish kumar

The DELETE command is used to remove rows from a table. A
WHERE clause can be used to only remove some rows. If no
WHERE condition is specified, all rows will be removed.
After performing a DELETE operation you need to
COMMIT or ROLLBACK the transaction to make the change
permanent or to undo it.

TRUNCATE removes all rows from a table. The operation cannot
be rolled back. As such, TRUCATE is faster and doesn't use
as much undo space as a DELETE.



DROP and TRUNCATE are DDL commands, whereas DELETE is a DML
command. Therefore DELETE operations can be rolled back
(undone), while DROP and TRUNCATE operations cannot be
rolled back.


Table is a basic unit of data storage in an oracle database.
It holds all user accessible data.

View is a virtual table
- It can be created on a table or another view.
- It is just like a window through which we can access or
change base table data.
- It does contain data of its own. It always takes data from
its base table.
- It is stored as a query in data dictionary.Whenever you
query a view it gets data from its based table using this query.

Constraints are great at maintaining database integrity for
database fields and relationships between database tables.

Triggers are great for checking past vs. current values and
making decisions based on that data.

What are different types of table joins?

0 Answers  

---

What does it mean to invest in the index?

0 Answers  

---

Can you roll back the ddl statement in a trigger?

0 Answers  

---

What is sql stored procedure?

0 Answers  

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  

---

What is the meaning of resultset type_scroll_insensitive?

0 Answers  

---

What is the full form of ddl?

0 Answers  

---

Difference between rowid and rownum in SQL?

1 Answers   Virtusa,

---

What is row_number()?

0 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

How to insert new line characters into strings?

0 Answers  

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---