Differentiate between % rowtype and type record.

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,

---

What is keys and its types?

0 Answers  

---

Is sql dba a good career? : SQL DBA

0 Answers  

---

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

3 Answers   TCS,

---

Compare SQL and PL/SQL.

3 Answers  

---

What are triggers, and when would you use them?

3 Answers  

---

Is foreign key mandatory?

0 Answers  

---

give the syntax of grant and revoke commands? : Sql dba

0 Answers  

---

What is difference between sql function and stored procedure?

0 Answers  

---

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---

how to convert character strings to dates? : Sql dba

0 Answers  

---