Answer Posted / shivashanker

Procedure is named pl/sql block or sub-program used to manipulated the data within the databse.OR It is used to perform some action within the databse

what are the properties and different types of sub-queries? : Sql dba

1034

---

What is a design view?

924

---

what is a trigger in mysql? : Sql dba

1146

---

How will you distinguish a global variable with a local variable in pl/sql?

1153

---

How to return multiple rows from the stored procedure?

970

---

Explain alias in sql?

1051

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1074

---

when MSQL8.0 is in market

2076

---

how to get a list of indexes of an existing table? : Sql dba

960

---

Can sql function call stored procedure?

1025

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1582

---

what is csv? : Sql dba

999

---

How we can update the view?

1049

---

Why we use joins in sql?

984

---

What is dml statement?

956

---