Answer Posted / sujit pingale

select to_char(sysdate, 'day') from dual;

This will print output: tuesday i.e

select last_day(sysdate) from dual;

This will print output: 31-Aug-14

what is 'mysqlshow'? : Sql dba

1008

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1064

---

What is cursor status?

1178

---

what is the difference between myisam static and myisam dynamic? : Sql dba

1052

---

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

2104

---

What is pl sql script?

1014

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1584

---

Is grant a ddl statement?

890

---

How do I create a memory optimized filegroup?

949

---

what are properties of a transaction? : Sql dba

1078

---

what are numeric data types? : Sql dba

1051

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1079

---

What is offset in sql query?

1095

---

Can we enter data in a table in design view?

955

---

How many subqueries can be nested in a statement?

974

---