Answer / priya ramesh

grant - it is a statement of DCL (DATA CONTROL LANG)

granting previleges to the user

Commit,Rollback and savepoint are the statements of TCL (TRANSACTION CONTROL LANG)

Commit - Makes a permanent change to the data in the database
Rollback - The changes made in the data can be undone using roll back statement

savepoint - The point upto which the data can be commited while the rest of the datas can be rollbacked as necessary

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,

---

what are the differences among rownum, rank and dense_rank? : Sql dba

0 Answers  

---

what are the difference between clustered and a non-clustered index? : Sql dba

0 Answers  

---

What is range partitioning?

0 Answers  

---

How much does sql certification cost?

0 Answers  

---

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

---

What is the difference between sql and t sql?

0 Answers  

---

What is the clause we need to add in function body to return variable?

0 Answers  

---

What is record data type?

0 Answers  

---

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

---

What is varchar data type in sql?

0 Answers  

---