Answer / Keshaw Kumar

Numeric values can be included in SQL statements by directly typing them into the query. For example, if you want to select all records where a column named 'age' is equal to 25, you can use SELECT * FROM table_name WHERE age = 25;

What is the difference between sql/pl-sql/embeded sql?

3 Answers  

---

Does asenumerable execute the query?

1 Answers  

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1 Answers  

---

What is the difference between clustered and non-clustered indexes?

1 Answers  

---

In packages the source code is compiled into p code ? how do we describe the p code

3 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  

---

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,

---

What is multiple partition?

1 Answers  

---

What are the advantages of sql? Explain

1 Answers  

---

Which data type doesn't allow null data type?

6 Answers   TCS,

---

What are its different types of dbms?

1 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---