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 where clause in sql?

1 Answers  

---

What does (*) mean in sql?

1 Answers  

---

What is the difference between pl and sql?

1 Answers  

---

What are the two types of cursors in pl sql?

1 Answers  

---

How do you get column names only for a table (sql server)?

1 Answers  

---

Its possible to add more than one primary key for the table

4 Answers  

---

Enlist the data types that can be used in pl/sql?

1 Answers  

---

Is it possible to update views?

1 Answers  

---

Explian rowid, rownum? What are the psoducolumns we have?

1 Answers  

---

How do you use collections in procedure to return the resultset?

1 Answers  

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

---