Does a join table need a primary key?

0 Answers  

---

what is data integrity

3 Answers   Fidelity, TCS,

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

What are the different tcl commands in sql?

0 Answers  

---

Explain the difference between rename and alias?

0 Answers  

---

Hi All, I am new to both this blog and technology. I was able to see a response for one of the questions on triggers as below. I would like to know why are we using " if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then" instead, can't we use " if sysdate = 'sunday' then". I can understand the use of "rtrim", but dont know y v r using to_char. I have seen this in many cases but did not get a convincible explaination. Please help me with this and do excuse if this question sounds silly. Thanks in advance...... create or replace trigger trg_sun before insert on <table name> begin if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then raise_application_error(-20345,'no transaction in sunday'); end if; end trg_sun;

2 Answers  

---

Explain how procedures and functions are called in a PL/SQL block ?

3 Answers  

---

What packages(if any) has oracle provided for use by developers?

1 Answers  

---

How many commands are in sql?

0 Answers  

---

What is pivot query?

0 Answers  

---

How can we make an if statement within a select statement?

0 Answers  

---

Name the different types of indexes in sql and define them.

0 Answers  

---