What is the difference between in and between in sql?

0 Answers  

---

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,

---

How do you define a foreign key?

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  

---

How many types of sql are there?

0 Answers  

---

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

1 Answers   HCL,

---

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

---

Compare SQL and PL/SQL.

3 Answers  

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

---

how to see the create table statement of an existing table? : Sql dba

0 Answers  

---

Is it possible for a table to have more than one foreign key?

0 Answers  

---

What is difference between table and view?

0 Answers  

---