In PL/SQL if we write select statement with INTO clause it may return two exceptions NO_DATA_FOUND or TOO_MANY_ROW .To avoid these execeptions. How do you write SQL statement in alternative way?

Ananda Kumar Behera

• Nov 12th, 2013

To avoid use:

Code
 

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 16th, 2013

We can use explicit cursor to avoid Oracle exception - NO_DATA_FOUND and TOO_MANY_ROWS.

Answer Question  Select Best Answer

dnkreddy

 Profile Answers by dnkreddy Questions by dnkreddy

• Nov 30th, 2008

8i-materilized views, instead of triggers, support internet, granting of columns
9i-timestamp, rename of column, new datatypes, rank, dense_rank, 9i joins

Rajendra Thanekar

• Apr 29th, 2007

1)? connect internal (SVRMGR) is not supported in 9i now you can manage database with SQL*plus.2) SPfile in 9i which is not available in previous version. Helpful for those init parameter those need ...

Answer Question  Select Best Answer

parveshdata

 Profile Answers by parveshdata Questions by parveshdata

• Jun 26th, 2009

Use show sga to know all the important parameters that are there for you by default setting of oracle or may be DBA has set at the time of installing the database in your init.ora or sp file. Many of ...

orafighter

 Profile Answers by orafighter Questions by orafighter

• Sep 6th, 2007

Hello sql>show sga , then it shows these parameters---- Total system global area---- Fixed size----Variable size----Database buffers----Redo buffers or can query from select * from v$sga

Answer Question  Select Best Answer

sik tauk

 Profile Answers by sik tauk Questions by sik tauk

• Apr 26th, 2007

If you are a DBA, login on the host using sqlplus to the database using sys as sysdba privilege.$ export ORACLE_HOME=<ORACLE_HOME>$ export ORACLE_SID=<ORACLE_SID>$ sqlplus "/ as ...

daniels

• Dec 18th, 2006

You could also do the following.dbms_utility.compile_schema(schema IN VARCHAR2,compile_all BOOLEAN DEFAULT TRUE,reuse_settings BOOLEAN DEFAULT FALSE);exec dbms_utility.compile_schema('SCOTT');

Answer Question  Select Best Answer

If you have an open cursor on a table, modify the same table and commit, what would happen?

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

There will not be any impact on the output even if we will insert (and commit) the data after cursor is opened. The output will be same as of the record set when cursor was opened and new row will not be selected in that operations.

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

There will not be any impact on the output even if we will insert (and commit) the data after cursor is opened. The output will be same as of the record set when cursor was opened and new row will not...

Answer Question  Select Best Answer

venkatagsubbaiah

 Profile Answers by venkatagsubbaiah Questions by venkatagsubbaiah

• Feb 4th, 2010

Create Table Tab1 as select  * from Tab2 where 1=2;

rajiv.sriraj

 Profile Answers by rajiv.sriraj Questions by rajiv.sriraj

• May 9th, 2008

HI if u want to get the same table structure which is already existing in ur database then SQL QUERY IS create table <table name> as select * from <table name which is already in DB> where...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Renu

• Jan 26th, 2007

---

Materialized View stores both - definition of the view and rows resulted from execution of the viewMain disadvantage of materialized view is that, its contents get outdated when underlying base table is modified .U can refresh Materialized View using DBMS_MVIEW.REFRESH

thiru

• Jun 26th, 2014

Its a one of the oracle object,its physical storage on the disk then (dbms_refresh)

shanitha

• Sep 11th, 2012

Materialized view is a database object that contains the results of a query..

Improve Answer

Deepika S Verma

• Mar 14th, 2014

TRUNC applies to numeric and Dates values Syntax- ------- TRUNC( number, [ decimal_places ] ) TRUNC ( date, [ format ] ) Example - --------- TRUNC(125.815) would retur...

shiiva

 Profile Answers by shiiva Questions by shiiva

• Aug 6th, 2013

We cannot compare Truncate & Trim. Truncate is a DDL command which deletes the content of a table completely, without effecting the table structure.

Trim is a function which alters the output of one of the column output of a select query.

Answer Question  Select Best Answer

AMRUT SWAGAT DWIVEDY

• Apr 18th, 2014

TRUNCATE Query

Code
 

Rakesh Anand

 Profile Answers by Rakesh Anand Questions by Rakesh Anand

• Aug 24th, 2013

Code
 

Answer Question  Select Best Answer

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

Snehal

• Jul 10th, 2012

View : View exists logically.Its a virtual table.Whenever we are firing a query on a view we are getting a data from a table. But for a snapshot it is not a case... snapshot itself store a data.. refr...

ravinder lathwal

• May 15th, 2012

Snapshot is just like print screen. or materialized view is actual table.
snapshot is read only.you will find it same stage every time.
but materialized view is update mode.always you will find it a new stage.

Answer Question  Select Best Answer

RAM

• Aug 8th, 2012

TOAD,PUTTY WITH LIINUX/UNIX ,ORACLE FORMS,ORACLE REPORTS.

srikanth

• Jul 22nd, 2012

Toad, Putty,Bmc remedy

Answer Question  Select Best Answer

Ranjan

• Dec 12th, 2017

Try with ed/

vipul gupta

• Mar 22nd, 2017

Is there any way to fix the ed command issue or every time we need to use define_editor=command.
Is there any permanent solution so please tell me.

Answer Question  Select Best Answer

1. Queries for Nth maximum Nth row?2. In One table there are 5 fields. empno, ename, deptcd, managr_id, salary.Select the departments whose sum of the salary greater than the sum of salaries of any department?3. When index will be usd in the Query?

mahesh

• Aug 12th, 2013

Code
 

priyank

• May 10th, 2012

Use Case in update statement

Answer Question  Select Best Answer

Rahul

• Jul 11th, 2013

It retrieve or fetch all data from Emp table,and show all data of table like Emp as result.

vaasukk@yahoo.com

• Dec 13th, 2012

First it will check the syntax and semantics in library cache, after that it will create execution plan. Already data in the buffer cache it will directly return to the client. If not it write the fetched to the dB buffer cache after that it will send server. Server sends to the client.

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

Harishankar Sahu

• Nov 25th, 2017

Truncate is faster. Because, its a DDL. So, no rollback information is stored. Truncate also does not consider integrity constraints; while delete does.

shaik

• Sep 7th, 2016

DELETE is a Safe mode of operation as it can be ROLLBACKed whereas TRUNCATE is Faster operation but cannot be ROLLBACKed.
DELETE can be Few Records based on WHERE Clause while the TRUNCATE is a Full operation.

Answer Question  Select Best Answer