Home
Q&A
Education
Technology
Credit
General
Health
Insurance
Questions
Ask a Question
How many types of cursors are available in PL/SQL?
Home
Technology
How many types of cursors are available in PL/SQL?
asked
Dec 17, 2020
in
Technology
by
JackTerrance
How many types of cursors are available in PL/SQL?
interview-question-answer
technology-questions-answers
1
Answer
0
votes
answered
Dec 17, 2020
by
JackTerrance
There are two types of cursors in PL/SQL.
Implicit cursor, and
explicit cursor
Related questions
0
votes
Q: How many types of Streams are available?
How many types of Streams are available? a) 5 b) 4 c) 6 d) 3 e) 3 🔗Reference ... and Answers 🔗Source: Continuous Integration Interview Questions and Answers...
asked
Dec 20, 2020
in
Technology
by
Editorial Staff
interview-question-answer
technology-questions-answers
0
votes
Q: Explain how many types of filters are available in Tableau? t
Explain how many types of filters are available in Tableau?...
asked
Nov 1, 2020
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: What are the cursor attributes used in PL/SQL?
What are the cursor attributes used in PL/SQL?...
asked
Dec 17, 2020
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: How many types of relationships available in Laravel Eloquent?
How many types of relationships available in Laravel Eloquent?...
asked
Sep 30, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: How many Types of Roles Available in Oracle Fusion?
How many Types of Roles Available in Oracle Fusion?...
asked
Nov 21, 2020
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: PL/SQL "Where" conditional "WHERE" clause
I am trying to make a a query against a table and am kind of stuck in constructing the WHERE ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
May 1, 2022
in
Education
by
JackTerrance
plsql
0
votes
Q: pl sql & java - creating dynamic query
I have a dilemma, I'm using Java and Oracle and trying to keep queries on PL/SQL side. Everything ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Mar 22, 2022
in
Education
by
JackTerrance
java
0
votes
Q: pl sql & java - creating dynamic query
I have a dilemma, I'm using Java and Oracle and trying to keep queries on PL/SQL side. Everything ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Mar 21, 2022
in
Education
by
JackTerrance
java
0
votes
Q: Error on function in PL/SQL
I tried to create following function: CREATE OR REPLACE function CATEGORYTEST(n in number) return VARCHAR(200 ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Feb 18, 2022
in
Education
by
JackTerrance
oracleplsql
0
votes
Q: PL/SQL function to view maximum salary
I have function that receives department name and an aggregation operation (average, maximum, minimum) and applies ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Feb 17, 2022
in
Education
by
JackTerrance
plsqlaggregate-functions
0
votes
Q: Error on function in PL/SQL
I tried to create following function: CREATE OR REPLACE function CATEGORYTEST(n in number) return VARCHAR(200 ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Feb 17, 2022
in
Education
by
JackTerrance
oracleplsql
0
votes
Q: Error on function in PL/SQL
I tried to create following function: CREATE OR REPLACE function CATEGORYTEST(n in number) return VARCHAR(200 ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Feb 16, 2022
in
Education
by
JackTerrance
oracleplsql
0
votes
Q: If no header is specified, the block is said to be an _______________ PL/SQL block.
If no header is specified, the block is said to be an _______________ PL/SQL block. (a) Strong (b ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked
Oct 11, 2021
in
Education
by
JackTerrance
0
votes
Q: We use ______________ name PL/SQL program objects and units.
We use ______________ name PL/SQL program objects and units. (a) Lexical Units (b) Literals (c) ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked
Oct 11, 2021
in
Education
by
JackTerrance
0
votes
Q: A line of PL/SQL text contains groups of characters known as
A line of PL/SQL text contains groups of characters known as (a) Lexical Units (b) Literals (c ... Query Optimization in portion Query Processing Techniques of Database Management...
asked
Oct 10, 2021
in
Education
by
JackTerrance
...