PLSQL Scenario based questions
1.Write a PLSQL block to print the list of employee names (Click Here for Answer)
2.Write a procedure to select all the data from one table using bulk collect and insert records to another table in batches of 20
Subscribe to:
Posts (Atom)
-
SQL to Find number of saturday and sunday in the current month SELECT TO_CHAR(c_date,'DAY') day, COUNT(*) FROM ...
-
Create the profiler tables from the table creation script available in oracle home directory @C:\orclee18c\WINDOWS.X64_180000_db_home_OR...
-
1. Oracle PLSQL Practical Interview Questions Write a PLSQL block to print the list of employee names set serveroutput on DECLA...
The way you explain is excellent.please do post more real time scenario based interview question.
ReplyDeleteif we create a trigger on after insert on table and in that trigger two procedure is called and that one procedure return an exception
ReplyDeletethwn what will be the output ?
scnerio:>
procedure
(
insert into table_one values (1,2);
commit;
) -- procedure end here
we hace a trigeer on table_one and that trigeer return an exception then the above records inserted in table or rollbacked ?
Could you please update on below request.
ReplyDeleteWrite a procedure to select all the data from one table using bulk collect and insert records to another table in batches of 20
Sir request you i want to trigger dbms_scheduler_jobs which personal job is enabling disabling just i want requirements
ReplyDeleteHi Siva sir
ReplyDeletePlease help me out on this scenario
ID NAME WK1 WK2 WK3
123 CIENA 108000 -1000 -10800
124 CIENA 2168000 -21680 -216
125 CIENA -10042 10042 -10042
126 KYOCE 5000 -2000 -5000
Need to fetch least negative value from each row...
For example ID :- 123 row is having two negative values from different columns i need to fetch -10800 as it is least from WK3 column
and ID:- 124 row is two negative values need fetch -21680 from WK2 column
Like this from all rows