Recent questions and answers in PL/SQL

0 votes

Can The Size Of The Parameter Passed To The Procedure Be Restricted In The Procedure Definition?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

What Does The Replace Option Indicates In The Procedure Definition?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Explain what Is A Procedure? Can It Be Stored In The Database?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Give The Basic Block Structure Of A Subprogram ?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

+1 vote

Explain what Is The Difference Between The Code Syntax Of An Anonymous Block And Named Subprogram Block?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Explain what Is The Basic Difference Between Procedure And Function?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Explain what are The Two Different Types Of Subprograms In Pl/sql?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Explain what Is An Anonymous Block?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Explain what Is A Subprogram? Explain what are Its Advantages?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Which Column In The User.triggers Data Dictionary View Shows That The Trigger Is A Pl/sql Trigger?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Write The Alter Statement To Enable All The Triggers On The T.students Table ?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Explain what are Conditional Predicates?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

+1 vote

Is It Possible To Include An Insert Statement On The Same Table To Which The Trigger Is Assigned?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Can Instead Of Triggers Be Used To Fire Once For Each Statement On A View?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Is It Possible To Define An Exception Within A Trigger?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

What Does The Base_object_type Column Shows In The User.triggers Data Dictionary View?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Is It Possible To Create Startup Or Shutdown Trigger For On-schema?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Can Cursors Be Part Of A Trigger Body?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Can A Select Statement Fire A Trigger?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Is It Possible To Pass Parameters To Triggers?

answered Mar 18, 2021 in PL/SQL by sharadyadav1986 (30.6k points)

0 votes

Does User-triggers Have Entry For Triggers With Compilation Errors?

answered Mar 15, 2021 in PL/SQL by Robindeniel (19.9k points)

0 votes

How Can You View The Errors Encountered In A Trigger?

answered Mar 15, 2021 in PL/SQL by Robindeniel (19.9k points)

0 votes

Does A User_objects View Have An Entry For A Trigger?

answered Mar 15, 2021 in PL/SQL by Robindeniel (19.9k points)

0 votes

Are Ddl Triggers Fired For Ddl Statements Within A Pl/sql Code Executed Using The Dbms.sql Package?

answered Mar 15, 2021 in PL/SQL by Robindeniel (19.9k points)

0 votes

Do Triggers Have Restrictions On The Usage Of Large Datatypes, Such As Long And Long Raw?

answered Mar 15, 2021 in PL/SQL by Robindeniel (19.9k points)

0 votes

Explain what Is The Difference Between Alter Trigger And Drop Trigger Statements?

answered Mar 15, 2021 in PL/SQL by Robindeniel (19.9k points)

0 votes

Can A Commit Statement Be Executed As Part Of A Trigger?

answered Mar 15, 2021 in PL/SQL by Robindeniel (19.9k points)

0 votes

Can A View Be Mutating? If Yes, Then How?

answered Mar 15, 2021 in PL/SQL by Robindeniel (19.9k points)

0 votes

Can Triggers Stop A Dml Statement From Executing On A Table?

answered Mar 15, 2021 in PL/SQL by Robindeniel (19.9k points)

0 votes

Explain what Is The Meaning Of Disabling A Trigger?

answered Mar 15, 2021 in PL/SQL by Robindeniel (19.9k points)

To see more, click for all the questions in this category.

...