What is substitution variable in pl sql?

1043

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4023

What is a loop in sql?

983

Which is faster joins or subqueries?

989

What is #table in sql?

1098

How do you drop a trigger?

987

How can you tell the difference between an index and a view?

937

Name some usages of database trigger?

1019

Explain what is a field in a database and record in a database?

1097

Give the order of sql select?

1135

How are functions and procedures called in PL/SQL?

1227

Is json a nosql?

980

which types of join is used in sql widely? : Sql dba

982

Define implicit and explicit cursors.

1144

What is view explain with example?

930