Answer Posted / nazeer

pseudo column act as database table column, but not actually the exact column in the table....we can fetch values from the pseudo column....

The Columns are..
user,
userid,
rownum,
rowid,
level,
nextval,
curval,
sysdate.......

What is trigger point?

947

---

Can we commit in trigger?

920

---

How to process query result in pl/sql?

1057

---

Is oracel sql developer written in java?

1057

---

What is the difference between having and a where in sql?

1031

---

Determine if oracle date is on a weekend?

980

---

What are sql queries used for?

974

---

What is mutating trigger?

965

---

What are the advantages of pl sql over sql?

959

---

What is rowtype?

953

---

How does sql developer connect to oracle database?

947

---

Does mysql_real_escape_string prevent sql injection?

906

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1057

---

What are the two types of exceptions in pl/sql?

962

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1976

---