Can we use loop in sql?



Can we use loop in sql?..

Answer / Sangeeta Yadav

No, SQL (Structured Query Language) does not support loops. SQL is a declarative language designed for data manipulation and retrieval, while loops are procedural constructs used to control the flow of execution in programming languages.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are hotfixes and patches?

1 Answers  


Write a query to find the names of users that begin with "um" in sql?

1 Answers  


List out the acid properties and explain?

1 Answers  


Why do we use view in sql?

1 Answers  


I want to execute a piece of code before calling a procedure. How to achieve it?

1 Answers   Oracle,


What Is a Trigger? How Do You Use It?

3 Answers  


What is sql indexing?

1 Answers  


How to trace the errors in pl/sql block code?

5 Answers   TCS,


how to escape special characters in sql statements? : Sql dba

0 Answers  


there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,


one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,


What is pivot query?

1 Answers  


Categories