Write a query to find the names of users that begin with "um" in sql?

0 Answers  

---

Does execute immediate commit?

0 Answers  

---

what is a constraint? : Sql dba

0 Answers  

---

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

---

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

---

Explain what is a subquery ?

0 Answers  

---

Is primary key a clustered index?

0 Answers  

---

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,

---

What is constant in pl sql?

0 Answers  

---

Which language is used in sql?

0 Answers  

---

define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.

5 Answers  

---

What is difference between % ROWTYPE and TYPE RECORD ?

2 Answers  

---