How do you send the output of your SQL* Plus session to a text operating system file

prateek2612

 Profile Answers by prateek2612 Questions by prateek2612

• May 15th, 2011

See spool command

lanka_satya

 Profile Answers by lanka_satya Questions by lanka_satya

• Jul 4th, 2008

well you want to see the output ina  text file............this can be done by spooling the data;for example..you want to see the output of the details of all employees:do the following steps:spoo...

Answer Question  Select Best Answer

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 16th, 2007

Hi shravanam,Wht is this u r wrong?Non-Euqijoin : Join more than one table with other than equlity operator (i.e. BETWEEN ... AND....)

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

Join is a query which retrieves related columns or rows from multiple tables. Self Join - Joining the table with itself. Equi Join - Joining two tables by equating two common columns. Non-Equi Join - ...

Answer Question  Select Best Answer

saginandkishore

 Profile Answers by saginandkishore Questions by saginandkishore

• Jun 20th, 2008

To execute sqlplus via Unix shell scripts the following parameters need to be initialized.(1.) ORACLE_HOME export ORACLE_HOME=Path to <ORACLE_HOME>(2.) ORACLE_SIDexport ORACLE_SID=Actual ORACLE_...

srinsr

• Mar 14th, 2007

$ORACLE_SQLPLUS -s $TCS_ORACLE_ID > $ORALOG 2>&1 <<EOFset serveroutput onset heading offset feedback offset verify offset linesize 250set pagesize 0set termout offexec solpk_upd_tcash ( '$SRC_SYS_CD', '$Date');commit;quit;EOF

Answer Question  Select Best Answer

lanka_satya

 Profile Answers by lanka_satya Questions by lanka_satya

• Jul 4th, 2008

oracle supports two types of joins: 1.oracle joins   cartesian join   equi join   non equi join   self join   outer  join is exhibited ...

pawan ahuja

 Profile Answers by pawan ahuja Questions by pawan ahuja

• Mar 8th, 2006

Hi all,Actually we r talking abt the ANSI join syntax,That's available in oracle 9i.this join cannotbe run in lower version means oracle 8i(8.17),oracle 9i releases1.The join syntax is left outer join,rigth outer join,full outer join.natural join,RegardsPawan Ahuja91(9342927335)  

Answer Question  Select Best Answer

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