SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---

What is the starting oracle error number?

0 Answers  

---

I want to know last five transactions or records from emp table, from now?

11 Answers   Wells Fargo,

---

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

0 Answers  

---

How can we optimize a sql query?

0 Answers  

---

What is cursor and its types?

0 Answers  

---

Show code of a cursor for loop.

0 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---

What is asqueryable?

0 Answers  

---

What are stuff and replace function?

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,

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  

---