How can you get sql*loader to commit only at the end of the load file? : aql loader

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 data type in database?

0 Answers  

---

Does mysql support pl sql?

0 Answers  

---

What is memory optimized?

0 Answers  

---

---

What is sql and db2?

0 Answers  

---

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

---

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

5 Answers   TCS,

---

Which are the different character-manipulation functions in sql?

0 Answers  

---

Is sql difficult?

0 Answers  

---

What are sql ddl commands?

0 Answers  

---

What is the difference between joins?

0 Answers  

---