Answer Posted / ansupriya

SELECT LENGTH(REPLACE(TRANSLATE('HELLO','HEO',' '),' ')) FROM DUAL

What is sql injection vulnerability?

945

---

List different type of expressions with the example.

935

---

What is integrity in sql?

1046

---

What is t-sql? : Transact sql

988

---

what are the authentication modes in sql server? : Sql dba

1065

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1154

---

How can a function retun more than one value in oracle with proper example?

1074

---

what are numeric data types? : Sql dba

1064

---

how to show all tables with 'mysql'? : Sql dba

1118

---

what is text? : Sql dba

1073

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1269

---

What is on delete restrict?

1000

---

Does inner join return duplicate rows?

978

---

Why cross join is used?

1078

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2113

---