Answer / rapaka srivani

the answer will be "no rows selected" because in question
we used a word called 'dual'. 'dual' is a default table in
SQL where it doesn't contain data. so the answer will
be 'no rows selected'.

Answer / jjjjjj

the answer id 'high'

what is the use of friend function? : Sql dba

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,

---

What is informix sql?

0 Answers  

---

How many functions are there in sql?

0 Answers  

---

What is the difference between inner join and natural join?

0 Answers  

---

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

---

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---

What is pessimistic concurrency control? : Transact sql

0 Answers  

---

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers   Reliance,

---

what is sql optimization

1 Answers   Fidelity,

---

what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,

---

write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,

---