Answer / 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).

What is union and union all keyword in sql?

1 Answers  

---

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

1 Answers  

---

What is parallel hint?

1 Answers  

---

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

---

What is mdf ldf and ndf?

1 Answers  

---

Is sqlexception checked or unchecked?

1 Answers  

---

Is sql difficult?

1 Answers  

---

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

---

Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,

---

I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1 Answers   MCN Solutions,

---

Write a query to get last 10 records from the table.

12 Answers   iNautix,

---