A view is created on a table then i dropped the base table and created the base table once again with the same name then that view will works or not?

Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Feb 5th, 2008

The view will be INVALID,so you need to re-compile it after create that base table...

Ashok Kumar choubey

• May 23rd, 2007

It will work either after base table drop and recreate or base table alteration. Enjoy

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 1st, 2008

Force View: creates the view regardless of whether or not the base tables exist or whether the user has privileges on them. The user still can’t execute the view, but he or she can create it. No...

Lavanya Chowdary

• May 6th, 2007

Generally we are not supposed to create a view without base table. If you want to create any view without base table that is called as Force View or invalid view.?Syntax: CREATE FORCE VIEW AS < SELEC...

Answer Question  Select Best Answer

roniprasan

 Profile Answers by roniprasan Questions by roniprasan

• Sep 2nd, 2007

Raise_application_error(error number,error discription)

aseemnaithani

 Profile Answers by aseemnaithani Questions by aseemnaithani

• May 3rd, 2006

Hi,,it is Raise_Application_error

Answer Question  Select Best Answer

ace1234567

 Profile Answers by ace1234567 Questions by ace1234567

• Mar 4th, 2015

Please find the template. Using out type parameter we can return more than one value from a function.

Code
CREATE OR REPLACE FUNCTION FUN_TEST(var1 VARCHAR2,var2 VARCHAR2,result OUT VARCHAR2) RETURN NUMBER
IS
.
.
BEGIN
.
.
END;

shyam

• Mar 2nd, 2015

Yes, we return more than one value in function using package. Example::

Code
create package pack
is
type mul_val is record
(emp_id employees.employee_id%type,
emp_name employees.last_name%type);
end pack;

and the return type of function is that pack type.....

Answer Question  Select Best Answer

Devanath Behera

• Oct 26th, 2017

The basic difference between Normal Cursor and Ref Cursor is as follows: 1. A Normal Cursor is a simple cursor which act as a static one where as Ref Cursor is a Dynamic Cursor which acts dynamically...

Rupesh

• Aug 29th, 2017

Normal cursor is associated with one select statement but ref cursor is associated with more than one select statement.ref cursor is dynamics cursor.

Answer Question  Select Best Answer

ravi.allam9

 Profile Answers by ravi.allam9 Questions by ravi.allam9

• Jun 4th, 2008

C. Table B gets created,but no rows gets inserted into Table A

Guest

• Jan 4th, 2007

hian empty table table (B) will be created there is a mistake un the first statementno need to commit a Create instruction, so the rollback will have no effectgood luck

Answer Question  Select Best Answer

 A FUNCTION is always returns a value using the return statement.        A  PROCEDURE   may  return one or more values through parameters or may not return at all.

Read Best Answer

Editorial / Best Answer

krishnaindia2007  

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Member Since Sep-2007 | May 3rd, 2008

---

1. Function is mainly used in the case where it must return a value. Where as a procedure may or may not return a value or may return more than one value using the OUT parameter.
 
2. Function can be called from SQL statements where as procedure can not be called from the sql statements

3. Functions are normally used for computations where as procedures are normally used for executing business logic.

4. You can have DML (insert,update, delete) statements in a function. But, you cannot call such a function in a SQL query.

5. Function returns 1 value only. Procedure can return multiple values (max 1024).

6.Stored Procedure: supports deferred name resolution. Example while writing a stored procedure that uses table named tabl1 and tabl2 etc..but actually not exists in database is allowed only in during creation but runtime throws error Function wont support deferred name resolution.

7.Stored procedure returns always integer value by default zero. where as function return type could be scalar or table or table values

8. Stored procedure is precompiled execution plan where as functions are not.
 
9.A procedure may modify an object where a function can only return a value The RETURN statement immediately completes the execution of a subprogram and returns control to the caller.

mahendra pal

• Sep 18th, 2018

Procedure may or may not return value

mangesh patil

• Aug 22nd, 2017

Procedure may or may not return value where as function should return one value.

Improve Answer

Read Best Answer

Editorial / Best Answer

Answered by: Sailaja Pasupuleti

• Dec 4th, 2005

---

    A sub-query is a part of query.  Sub-queries are useful to find unknown value(s).

   Ex:  To find details of employees who are getting maximum salary.

         In this requirement, the maximum salary not mentioned.

Solution:    

To find maximum salary, 

          select max(sal) from emp;

For that maximum salary the employee details, 

          select * from emp where  sal = (select max(sal) from emp);

So, in the above query, "select max(sal) from emp"  is also a query but it returns a value (unknown or not given) and compares with "sal" column.  This query is called sub-query.

kshsingh1

 Profile Answers by kshsingh1 Questions by kshsingh1

• Jan 22nd, 2007

A query nested within another SQL statement is called a subquery.

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 25th, 2006

Simple reply nalini ..goodnagthumati_nagaraju@yahoo.co.in

Improve Answer