Answer Posted / Surya Prakash

There are several types of literals available in PL/SQL, including string literals (enclosed by single or double quotes), numeric literals (integer, floating-point numbers), date literals (enclosed by to_date function or using the format dd-mon-yyyy hh24:mi:ss), and Boolean literals (TRUE and FALSE).

Is inner join faster than left join?

1265

---

What is the current version of sql?

1082

---

Do we need to rebuild index after truncate?

1114

---

what is dbms? : Sql dba

1048

---

Does group by remove duplicates?

1100

---

How do I remove duplicates in two columns?

1163

---

what are all the common sql function? : Sql dba

1113

---

what is bcp? When does it used? : Sql dba

1040

---

how many tables will create when we create table, what are they? : Sql dba

1129

---

define sql insert statement ? : Sql dba

1086

---

what are the advantages of sql ? : Sql dba

1126

---

Can we use distinct and group by together?

1116

---

how to escape special characters in sql statements? : Sql dba

1097

---

If a cursor is open, how can we find in a pl/sql block?

1226

---

what are aggregate and scalar functions? : Sql dba

1116

---