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 ...
-
1. Oracle PLSQL Practical Interview Questions Write a PLSQL block to print the list of employee names set serveroutput on DECLA...
-
Create the profiler tables from the table creation script available in oracle home directory @C:\orclee18c\WINDOWS.X64_180000_db_home_OR...
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
This comment has been removed by the author.
ReplyDeleteCan you Create Detailed Video about Oracle TKPROF?
ReplyDelete