Answer / Mohit Kumar Prasad

There are several SQL statements with defined purposes:n
1. SELECT: Retrieves data from a database.
2. INSERT: Inserts new records into a table.
3. UPDATE: Modifies existing records in a table.
4. DELETE: Deletes records from a table.
5. CREATE: Creates database objects such as tables, indexes, and procedures.
6. ALTER: Modifies the structure of existing database objects.
7. DROP: Deletes database objects.
8. TRUNCATE: Removes all records from a table.
9. COMMIT: Saves changes permanently.n10. ROLLBACK: Undoes all changes since the last commit.

wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

3 Answers   Apollo,

---

How do I add a database to sql?

1 Answers  

---

How do you exit in sql?

1 Answers  

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

1 Answers   TCS,

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1 Answers  

---

What is sap sql anywhere?

1 Answers  

---

package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,

---

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

---

Explain the working of primary key?

1 Answers  

---

What is replication id?

1 Answers  

---

what is 'mysqlcheck'? : Sql dba

1 Answers  

---

Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  

---