Answer Posted / kuldeep

select * from
(

SELECT (TRUNC (SYSDATE, 'yyyy') + LEVEL - 1) dt,
TRIM(TO_CHAR ((TRUNC (SYSDATE, 'yyyy') + LEVEL - 1), 'Day')) dy
FROM DUAL
CONNECT BY LEVEL <= 365

)
where dy='Friday'

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1125

---

What is constant in pl sql?

983

---

What is sql profiling in oracle?

1010

---

What are keys in sql?

957

---

What is the usage of when clause in trigger?

1007

---

What is cursor and why it is required?

1121

---

When is the explicit cursor used ?

990

---

what is the use of set statement in tsql? : Transact sql

960

---

Is sql low level language?

973

---

Can a foreign key be null?

1037

---

What is the difference between microsoft access and sql server?

1003

---

Can a select statement fire a trigger?

1105

---

How is pl sql different from sql?

1024

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1101

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

1343

---