Answer / vinay

Select distinct trans_id ,
to_char(trans_date,'MON') as TRANS_DATE,
count(trans_amt) over (partition by trans_id,to_char
(trans_date,'MON')) as No_OF_TRANSACTION
,sum(trans_amt) over (partition by trans_id,to_char
(trans_date,'MON')) as TRANS_AMOUNT,
debit_credit_indicator from CUSTOMER

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

---

What is extent clause in table space?

1 Answers   TCS,

---

what are the limitations of identity column? : Transact sql

0 Answers  

---

What is difference between table and view?

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

Does sql backup shrink transaction log?

0 Answers  

---

What is meant by temporal data?

0 Answers  

---

what are aggregate and scalar functions? : Sql dba

0 Answers  

---

discuss about myisam key cache. : Sql dba

0 Answers  

---

Can we create index on primary key?

0 Answers  

---

Is pl sql a scripting language?

0 Answers  

---

Is sql between inclusive?

0 Answers  

---