How do I find duplicates in sql?

0 Answers  

---

What are local and global variables and their differences?

0 Answers  

---

How do I install sql?

0 Answers  

---

How do I create a memory optimized filegroup?

0 Answers  

---

What are the different tcl commands in sql?

0 Answers  

---

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

What is the difference between distinct and unique in sql?

0 Answers  

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

0 Answers  

---

What is the difference between UNIQUE KEY and UNIQUE INDEX?

3 Answers   TCS,

---

what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---