Answer / Amritansh Mishra

Case Manipulation Functions in SQL and PL/SQL are used to convert or modify the case of strings. They include UPPER, LOWER, and INITCAP. The UPPER function converts all characters in a string to uppercase. The LOWER function converts all characters in a string to lowercase. The INITCAP function converts the first character of each word in a string to uppercase while leaving the rest of the characters in lowercase.

What is pl/sql and what is it used for?

4 Answers  

---

what are the demerits of sql?

1 Answers  

---

Define commit, rollback and savepoint?

1 Answers  

---

what is a trigger in mysql? Define different types of trigger. : Sql dba

1 Answers  

---

What are stored procedures in mysql?

1 Answers  

---

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

---

What are the uses of sysdate and user keywords?

1 Answers  

---

what is sql server agent? : Sql dba

0 Answers  

---

What is partition by in sql?

1 Answers  

---

What is a null value?

1 Answers  

---

Does sap use sql?

1 Answers  

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1 Answers  

---