Padmanathan

• Aug 20th, 2006

Hi,select owner, segment_name,bytes/1024/1024 "Size in Mb" from dba_segments where segment_type=<TABLE_NAME>This is total size physicall occupiedfor actual size:Analyze the table first using DBM...

harsha

• May 11th, 2006

How to get the size of the specified table i.e for a particular table??

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Feb 16th, 2009

Oracle is not truly a multidimensional database as Hyperion does..

aks

• Aug 19th, 2006

This statement is supported by the prescence of cube and rollup operators in oracle 9i which indicates that it is a multidimensional dbs

Answer Question  Select Best Answer

vijaydeep

 Profile Answers by vijaydeep Questions by vijaydeep

• Mar 1st, 2009

Ends the current transaction by making all pending data changes permanent.Is the simplest way to define.Transaction means start with an DML SQL Statement and end with one of the following? 1) A commi...

sweetytrivedi82

 Profile Answers by sweetytrivedi82 Questions by sweetytrivedi82

• Apr 25th, 2006

when a commit occurs in the transaction then the points are as mentioned:-1)an SCN is created & record in redo log buffer2)LGWR writes from Redo log buffer to redo log files3)oracle shows commit complete4)locks now can be released

Answer Question  Select Best Answer

sunnybhattacharjee

 Profile Answers by sunnybhattacharjee Questions by sunnybhattacharjee

• Jul 7th, 2010

You can store a jpeg file or a bitmap file in Oracle using the BLOB data type.It stores the jpeg image as a stream of bytes.In order to retrieve the data.You cant simply perform a select query over it...

sudheer

• Oct 6th, 2006

To store larger object in database use 'blob'

Answer Question  Select Best Answer

Variable portionThe variable portion is called variable because its size (measured in bytes) can be changed. The variable portion consists of: • large pool (optional)Provides working space for rman (although rman will also work without large pool). • Shared pool The shared pool is used for objects that are shared among all users. For example: table definitions, PL/SQL definitions, cursors and so on.

sairavi.dba

 Profile Answers by sairavi.dba Questions by sairavi.dba

• Jan 31st, 2009

In SGA, variable size is combination of shared pool, Java pool and Large PoolSQL> show sga;Total System Global Area  612368384 bytesFixed Size        &n...

dheeraj narula

 Profile Answers by dheeraj narula Questions by dheeraj narula

• Dec 27th, 2008

Dynamic SGA allows Oracle to set, at run time, limits on how much virtual memoryOracle uses for the SGA.So under dynamic(variable ) SGA portion, in intialization parameter file the parameterSGA_MAX_SI...

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

SYNTAX:INSERT INTO VALUES('&COLUMN1'(STRINGS,DATES),&COLUMN2);EXAMPLE:INSERT INTO EMP VALUES('&ENAME',&EMPNO);

rajanen

 Profile Answers by rajanen Questions by rajanen

• Jul 19th, 2006

SYNTAXinsert into table_name &column1,..... values (.......);e.g:insert into emp (emp_name,emp_id) values('&emp_name','&empid');

Answer Question  Select Best Answer

babuda

 Profile Answers by babuda Questions by babuda

• Jul 14th, 2008

I am not sure abt this but I was successful when I did this 2 years agoOpen tnsnames.ora filetake a back upchange the service from dedicated to permanent. I am not sure which one is itORCL01 =  (...

vijay

• Sep 12th, 2007

First you create database and user in Oracle 9iMapping for all database?using?tnsnames.ora file?and save it. Create DSN and connect

Answer Question  Select Best Answer

prasads_delight1

 Profile Answers by prasads_delight1 Questions by prasads_delight1

• Sep 28th, 2007

The varchar2(30) will take 30 bites. Because the size is specified as 30. if you entered a data of only 20 chars the remaining 10 will be transformed to the other field or row. By this the wastage of the disk space can be minimised.

pkjayan

 Profile Answers by pkjayan Questions by pkjayan

• Apr 29th, 2007

Varchar2 does not pad the unused bytes.it only uses the number of bytes inserted+1(end of charector) of course <30!

Answer Question  Select Best Answer

A view is nothing but a window of an existing table by which one can view and can also change the values in tables. The main point aspect of view is views have no storage space. For this reason views are also called as virtual tables. Thus in other words a view is a database object that gives a logical representation of one or more database tables.
As we have seen above views have no data for...

aardvax

 Profile Answers by aardvax Questions by aardvax

• May 17th, 2007

Please clarifythat if there are some changes made in view(created from a single  base table)would they reflect in the base table as well?

rayadurgamsudha

 Profile Answers by rayadurgamsudha Questions by rayadurgamsudha

• Mar 11th, 2007

A view acts like a mirror of the main table created. any changes made in the base table are seen in the view while changes made in the view cannot be seen in the base table except if the view is on a ...

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

SELECT TEXT FROM USER_SOURCE WHERE NAME='PROCEDURE/FUNCTION/PACKAGE/PACKAGEBODY'/

subasini

• Nov 17th, 2006

USER_SOURCE data dictionary view describes the text source of the stored objects owned by the current user wether it is procedure or function. Its columns (except for OWNER) are the same as those in All_source data dictionary view .ThanksSubasini 

Answer Question  Select Best Answer

gvvskumaran

 Profile Answers by gvvskumaran Questions by gvvskumaran

• Jan 15th, 2007

Do as john said.... use any data migration tool you will get that

John Thomas Ambadan

• Nov 29th, 2006

If u want to migrate ur access database to oracle, u can use Oracle migration work bench for microsoft access.for more details refer oracle documentation.

Answer Question  Select Best Answer

Abbireddy Anil Kumar

• Dec 15th, 2006

set_block_property('blockname',orderby clause,'fieldname);

subasini sahu

• Nov 17th, 2006

Before we have to clear the Block,Then in Set_Block_Property put the where conditions value.Thanks ,Subasini.

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

TRY THISSELECT ENAME||' ' ' '||'S' FROM EMP:

Jos? Baptista

• Nov 19th, 2006

HiYou just need to do this: ename||'''||'s'.If ename := 'Scott', the output is Scott's.RegardsJos? Baptista 

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

NO YOU CANNOT WRITE A FUNCTION WITHOUT RETURNING A VALUE.IT SHOULD RETURN ATLEAST ONE VALUE.........WITH REGARDS,SHARAT

Pawan Ahuja

• Dec 9th, 2006

No, we can not write a function witout a functionRegardsPawan Ahuja

Answer Question  Select Best Answer

raghu

• Nov 22nd, 2006

Hii think u studied in sree nipuna technologies right..............

Subasini

• Nov 17th, 2006

Data base link is a Database object .Basically we use it when we require to connect to other user or any remote user from current user.Syntax for creation is Create database link link_name connect to&...

Answer Question  Select Best Answer

Abbireddy Anil Kumar

• Dec 15th, 2006

declareserch_item number;a number;b number;beginserch_item:=:emp.empno;b:=:system.cursor_record;first_record;a:=:system.cursor_record;for i in a..b-1 loopif srich_item=:emp.empno thenmessage('Employee No Already Exists')raise form_trigger_failre;elsenext_record;end if;end loop;end;

Anil Kumar

• Dec 12th, 2006

declarea number;beginfirst_record;a:=system.current_record;for i in a..system.current_record-1 loopchecking codeend loop;

Answer Question  Select Best Answer

Amanpreet Kaur

 Profile Answers by Amanpreet Kaur Questions by Amanpreet Kaur

• Feb 21st, 2007

One has to configure jdbc odbc driver in case of windows. and set the oracle variables and environment paths. java will be connected to oracle.

PurnaChandarrao

• Feb 13th, 2007

Hai First you have to create DSN name ; Control Panel--->Administrative Tools--->DatabaseSources(ODBC) And give new DSN name and configure with your Data base either it is Oracle 8i or Oracle 9i se...

Answer Question  Select Best Answer

Means i have 150 tables in one system, i want to copy those tables into another system.

ravi.allam9

 Profile Answers by ravi.allam9 Questions by ravi.allam9

• Jun 4th, 2008

Using import/export

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

1. copy2. create table as select3. export/import

Answer Question  Select Best Answer

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 16th, 2007

Hi taraldesai! Y Not?Here is the example Try thisALTER TABLE table_nameADD (column datatype DEFAULT expr);(or)ALTER TABEL table_nameMODIFY (column datatype DEFAULT expr)

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

Specify parameter there is nothing like you are asking..like alter system set default ... wrongalter system set sql_trace=TRUE;

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Aug 27th, 2007

Actually Oracle is made for query purpose not for FTS, and it obviously depends upon your requirements. In FTS oracle server process reads all the blocks concerned with the table and it is not so when...

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

Depends, if you want certain columns then why to query whole data. bcoz it involves more IO, network traffic and many other things

Answer Question  Select Best Answer