Can a view be mutating? If yes, then how?
No Answer is Posted For this Question
Be the First to Post Answer
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
Is left join same as inner join?
If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING
10 Answers HCL, TCS,
How to get employee name from employee table which is the fiveth highest salary of the table
What is offset in sql query?
what is a field in a database ? : Sql dba
What is rowid in sql?
How can get second highest salary in sql?
In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop
Why trigger is used in sql?
How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?
How to download oracle sql developer?