What data types does pl/SQL have?

3 Answers  

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

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,

---

Does sql support programming?

0 Answers  

---

What does partition by mean in sql?

0 Answers  

---

what is the different between now() and current_date()? : Sql dba

0 Answers  

---

Why we use stored procedure instead of query?

0 Answers  

---

What are the advantages of sql? Explain

0 Answers  

---

What is trigger and how to use it in sql?

0 Answers  

---

what is the Default Libraries for Oracle Report 6i

0 Answers   IBM,

---

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

---