How to call DDL statements from pl/sql?4 25788
How to maintain the history of code changes of pl/sql?2 9153
what are Dynamic SQL statements?9 15402
What is pl/sql and what is it used for?4 10274
what is constraining table?2 8709
How pl/sql source code can be protected?2 6832
What can be a size of a pl/sql block? Is there any limit?2 8446
HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?2 4355
What are the advantages of VIEW?5 26657
Whis is not false in primary key?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
i have some prob lem to tell me about my self in interview first round ...
when MSQL8.0 is in market
What is Materialized View? In What Scenario we Use Materialized View?
what is the difference difference between procedure and packages
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID email@example.com Or taking tanning on this please do contact me
What is Temp Table and type of temp table?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
Difference between global and parameter variables?
What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?
C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.
What is your daily office routine?