balajiintech

• Jun 29th, 2007

Logs increase rapidly when large amount of data are inserted/deleted/updated. when Commit/Rollback is issued.

aniket

• Jun 20th, 2007

Std command to check logs is...trail -f .Thanks~Aniket

Answer Question  Select Best Answer

HARI SHANKAR SHARMA

• Jul 18th, 2011

Select aa_seq.currval from dual

Regards,
Hari Shankar Sharma

Hari Kiran P

• May 14th, 2007

You can get the current value of the Sequence by querying DBA_SEQUENCESColumn name is Last_numberThanksHari Kiran P.

Answer Question  Select Best Answer

gcvpgeek

 Profile Answers by gcvpgeek Questions by gcvpgeek

• Mar 17th, 2009

Say you are using the seq name temp_seqCREATE SEQUENCE temp_seqStart with 5
Increment by 2maxvalue 999999999999999999999999nocachenocycle
Above will create the sequence temp_seqTo use itINSERT INOT xyz
VALUES (temp_seq.nextval,'oracle')

lanka_satya

 Profile Answers by lanka_satya Questions by lanka_satya

• Jul 4th, 2008

Dear friend :  oracle generate sequence numbers with the help of predefined function called nextval.so if you want insert these generated sequence no you can do using <seq_name>.nextvalfor ...

Answer Question  Select Best Answer

You can also use tnsping utility on command prompt to check Oracle Net connectivity. Follow these steps to check the connection to particular SID.Open Command prompt.Write tnsping < SID for the database connectivity you want to check >If you get the message “Used TNSNAMES adapter to resolve the alias” then tnsping utility is able to resolve the service name.If you get “TNS-03505: Failed to resolve...

Chiranjeevi Manne

• Mar 30th, 2007

TNSPING is an Oracle network utility which checks for connectivity of a remote database.

kmkumar24

 Profile Answers by kmkumar24 Questions by kmkumar24

• Mar 29th, 2007

The TNSPING which helps to findout whether we have the connectivity to the particular database. It can be accessed from the dos prompt with either database name or with IP address.If it ping with that...

Answer Question  Select Best Answer

basmgokul

 Profile Answers by basmgokul Questions by basmgokul

• Apr 3rd, 2008

Hi,Step 1: save your script as .sql format.Step 2: to run your script, follow thisSQL> @'pathname'assume your script db.sql was saved in c:datascript, thenex:SQL>@'c:datascriptdb.sql'

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 13th, 2008

To run scriptSQl> @ C:script.txt

Answer Question  Select Best Answer

Rajeshree Metkar

• Aug 10th, 2007

Hello,As I go through the Comments related to the dual table I saw that there is a comment that we can not perform a DML operation on Dual table. Yes it is correct but only in case if you are log in t...

lieni

• Jul 30th, 2007

No., We cannot perform DML operations on Dual table. because we dont have the access permissions on that table.I say: But if we have access, eg. sysdba, we canFor security reasons,we hide data from th...

Answer Question  Select Best Answer

sreekumar_nair_it

 Profile Answers by sreekumar_nair_it Questions by sreekumar_nair_it

• Mar 27th, 2008

Dear All,LIFE OF SQL STATEMENTStep 1: Oracle Create a CursorFor every SQL, first a cursor is created (cursor creation can occur implicitly, or explicitly by declaring a cursor). Step 2: Oracle Parse S...

fancyoracle

 Profile Answers by fancyoracle Questions by fancyoracle

• Aug 16th, 2007

Once parsed, the SQL statement is available in the memory till the session is valid.

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