Oracle
1Z0-241 · Question #26
A SQL object is instantiated using the following statement: &SQL = CreateSQL("Select EFFORT_SPENT from PS_TASK_TBL where TASK=:1", TASK=TASK.TASK); Which PeopleCode statement can be used to…
The correct answer is C. &SQL.Fetch(&Var). See the full explanation below for the reasoning.
Question
A SQL object is instantiated using the following statement:
&SQL = CreateSQL("Select EFFORT_SPENT from PS_TASK_TBL where TASK=:1",
TASK=TASK.TASK);
Which PeopleCode statement can be used to reference a single row of data in &SQL?
Options
- A&SQL.Get(&Var);
- B&SQL.Next(&Var);
- C&SQL.Fetch(&Var);
- D&SQL.Select(&Var);
- E&SQL.Create(&Var);
- F&SQL.Execute(&Var);
How the community answered
(52 responses)- A4% (2)
- C81% (42)
- D10% (5)
- E4% (2)
- F2% (1)
Community Discussion
No community discussion yet for this question.