Answer / Chandra Bhanu Pratap Singh

The issue might be due to the scope of variables or functions. Inside a User-Defined Function (UDF), you cannot directly access table variables, system functions, or global variables as they are defined outside the UDF's scope. To make them available, you should declare them as parameters, use common table expressions (CTEs), or temporary tables within the UDF.

What are the purpose of Normalisation?

1 Answers   HCL,

---

Define clusters?

1 Answers  

---

Explain Active/Active and Active/Passive cluster configurations

2 Answers  

---

How to execute the cursor queries with "open" statements?

1 Answers  

---

What does it mean to be in union?

1 Answers  

---

Can we have more than one NULL in a column having unique constraint?

12 Answers   247Customer,

---

What is the contrast between sql and pl/sql?

1 Answers  

---

Is foreign key a primary key?

1 Answers  

---

What is an indexed view?

0 Answers  

---

What is the use of sign function?

1 Answers  

---

How do database indexes work?

1 Answers  

---

Will count(column) include columns with null values in its count?

1 Answers  

---