SQL & PL/SQL :: Difference Between Oracle 8i And 11g

Sep 22, 2011

I listen that there is a big diff B/W indexing in oracle 8i and oracle 11g.

what way the indexing is different B/W 8i and 11g.

View 3 Replies


ADVERTISEMENT

SQL & PL/SQL :: Difference Between Oracle 9i And 10g?

Apr 25, 2013

what are difference in between oracle 9i and 10g regarding with Sql queries?

View 1 Replies View Related

PL/SQL :: Difference Between Oracle DB 11.2.0.1.0 And 11.2.0.3.0?

Dec 18, 2012

When I use this sql: CREATE USER testuser IDENTIFIED BY "welcome1 " to create user in Oracle DB 11.2.0.1.0. I can login with testuser/welcome1, please notice the welcome1 is not end of black space in login.

But when I do the same thing in Oracle DB 11.2.0.3.0. I can't use this user login with any password. I tried welcome1, "welcome1 " but all failed.

Why there are this difference between 11.2.0.1.0 and 11.2.0.3.0, and since in 11.2.0.3.0 the create sql are success, what password is correct when login?

View 7 Replies View Related

Difference Between Oracle Version 10.2.0.3 And 10.2.03?

May 28, 2008

difference between oracle version 10.2.0.3 and 10.2.03.I searched a lots of sites to get the details about these versions but unable to collect.

Oracle released both version or 10.2.0.3 and 10.2.03 are same versions treated by oracle.

View 2 Replies View Related

SQL & PL/SQL :: Basic Difference Between Oracle 10g And 11g?

Jul 27, 2010

Basic difference between oracle 10g and oracle 11g

View 3 Replies View Related

SQL & PL/SQL :: Difference Between Oracle Procedure And Package?

Jan 7, 2013

difference between oracle procedure & package.

View 1 Replies View Related

Difference Between Oracle Database Server And Client?

Jul 22, 2011

Currently I am doing one Oracle installation.But very much confused where to start from. Since I am installing oracle on my personaly Laptop,do I need to install Oracle database server and Oracle client both or only installing database server is sufficient.

What is the exact difference between oracle database server and client.Only knowledge I have is that client is used to access database server remotely.are Oracle database server and client installable to be downloaded separately?

View 1 Replies View Related

Server Administration :: Difference Between LRM And Oracle Error

Jun 26, 2011

WHAT IS THE DIFFERENCE BETWEEN ORA ERROR AND LRM ERROR?

View 9 Replies View Related

Server Administration :: Difference Between A User And Schema On Oracle?

Apr 26, 2010

difference between a user and schema on Oracle.By difference, I do not mean what is a user and what is a schema.

I understand that if we create a user, the schema gets created by default for that user. Does that mean that we cannot create a user/schema alone.

What if I just want to create a user and grant him some read access on an existing schema or just want to create a schema.

View 7 Replies View Related

SQL & PL/SQL :: Difference Between File Catproc That Run After Creation Of Database In Oracle 9i /10g / 11g R2

Aug 18, 2010

I want to know what is the difference between the file catproc that we run after creation of the database in the Oracle 9i,10g and 11g r2. I have run that file in 11g R2 but it is taking more time and more over there are many new things that i saw in 11g R2 than what were there in 9i and 10g.

View 11 Replies View Related

SQL & PL/SQL :: Difference Between Sybase Raise Error And Rasie_application_error In Oracle?

May 6, 2010

I try to convert sybase raiseerror into oracle raise application error.

sybase code :

raiserror 20100 "can't add a contact number that's in the contact"

oracle

raise_application_error (
-20002, ':can''t add a contact number that''s in the contact');

the sybase error number 20100 unable to use in oracle due to the limitation of error number.RAISE_APPLICATION_ERROR should be negative and between -20000 and -20999.

how to use sybase error number in oracle?

View 2 Replies View Related

Server Administration :: Difference In SQL Results From Oracle 9i To 11gR2?

Jan 2, 2011

I've migrated from Oracle 9i to Oracle 11gR2, when i'm checking my application on Oracle 11gR2, i found that some of the query result are differed from the previous version of Oracle 9i, which is very illogical to me. I've checked the data for all related tables which are involved in one of the query. I've checked all indexes also. Still i'm not convinced that Oracle is doing anything wrong. I cannot recreate the whole scenario here, because of many tables involved in that query.

One of the sample query code.

select 'ProductMaster' producttype,e.schemecd,e.SCHEMESHORTDESC as SCHEMEDESC,to_char(e.schemefrdate,'dd/MM/yyyy')as schemefrdate, to_char(e.schemetodate,'dd/MM/yyyy') as schemetodate,e.mkid ,e.countrycd,e.statecd,e.districtcd,f.schemetype, a.productcd,a.packsizecd,a.packtypecd,a.sortorder1, a.countrycd,a.statecd,a.districtcd,a.p_uniqueid,a.mrp, (a.productcd ||'-'||b.countryname||'-'||c.statename||'-'||d.districtname|| ' -pkt.prc:'||a.pktprice ||' -mrp:'||a.mrp) as pcode
from wb.wbproductdetails a

[code]......

View 17 Replies View Related

RAC & Failsafe :: Oracle 9i - Difference Between Real Application Cluster And OPS

Jul 17, 2002

What is the different between the new RAC feature - real application cluster and OPS... for me it sound the same..

View 3 Replies View Related

PL/SQL :: Calculate Difference By Which Day Count Of Difference Is Going?

Oct 17, 2012

Detail table will look like below:

Product_id issue_date action_date Force_date
1 10/10/2012 10/10/2012 10/10/2012
2 10/10/2012 10/10/2012 10/10/2012
3 10/10/2012 13/10/2012 15/10/2012
[code]....

Need the data like

Issue_date count_action_date count_Force_date (diff(action_date,force_date) 1 2 3 4 5 6(days since over)

10/10/2012 3 4 1 4 2 1 0 0

How to get the data like this? automatically how to get 123.... and how to calculate the difference by which day the count of difference is going?

View 3 Replies View Related

RAC/ASM Clusterware Installation :: Difference Between Enterprise And Standard Edition For Oracle

Mar 18, 2013

In our current setup we have RAC on standard edition and client is now planning to go for Enterprise Edition but not yet decide because of cost. Is there any difference between Grid Infrastructure 11gR3 Enterprise edition and Standard Edition ?

They told me to first install Enterprise Edition and then will move to Standard Edition if they can't get the EE license so in that case do i have to re-install Grid infrastructure for standard edition?

View 6 Replies View Related

Networking And Gateways :: Oracle 11gR2 Database - Performance Difference Between Windows PC And On VMware

Feb 9, 2012

We are having major differences in performance when accessing an Oracle 11gR2 database from two different environments.

I won't sadden you with the gory details of the full application but I will use an indicative example of our problem.

We have SQL Developer in both environments. In each of these SQL Developer instances is a defined a connection to the same database on another machine. So there is the PC looking at a database and a virtual instance looking at the same database.

Selecting the '+' sign next to 'tables' for that connection, on the PC the list of four tables comes back in 4 seconds but on the virtual instance the list of the same four tables comes back in 1 minute and 50 seconds.

This sort of timing issue is repeatable for all accesses to the Oracle database on the third machine.

View 4 Replies View Related

Installation :: Oracle Database Express And Other Editions Installation Doc Difference?

Mar 20, 2013

My question is; I've been reading the Oracle database 11g R2 documentation at this link [URL]...

I passed a couple of days learning about all installation configuration parts including the desktop class and server class.As I was learning, So I had already downloaded Oracle Database Express 11g R2 for win32.

So as i had finished the installation guide I thought it's time to install the oracle now. I did it, and what I found was that there was not any option during installation that i read in above documentation. While trying to find about this difference i reached on documentation[URL]...

That is for express version only.

My question here is, Express edition, we use for learning purpose, But it doesn't look like it has all the stuff that we should learn during installation And what documentation I should follow from my above given two links?

View 3 Replies View Related

PL/SQL :: Static Table Creation In Oracle - Difference Between Static And Dynamic Table

Dec 11, 2012

Static Tables Creation In oracle & Diff Between Static table ,Dynamic table

View 2 Replies View Related

PL/SQL :: Difference Between Real Hijri Date With Oracle Hijri Date

Sep 18, 2012

In my application I show the Date in Hijri using the NLS setting. but the issue that "i face a deference between the real hijri date with oracle hijri date"

Assume that the real hijri date on 18-SEP-2012 was 02/11/1433 in hijri but in oracle was 03/11/1433

when I execute the following query it shows me "1433/11/03", but the actual Hijri date is "1433/11/02"

select to_char(to_date('20120918','YYYYMMDD'),'YYYY/MM/DD', 'NLS_calendar='''||'ARABIC hijrah') FROM DUAL;

View 8 Replies View Related

SQL & PL/SQL :: Get Max Difference Where Each Value Can Look At Only Next?

May 28, 2013

How do I get the max difference where each value can look at only the next value(ordered by date asc) on any particular day
example first row on 20090902 is 501.25 (earliest date)

756.2 - 501.25
4735.83 - 501.25
35.83 - 501.25

[code]....

View 19 Replies View Related

How To Get Date Difference

Jul 20, 2007

How one can get date difference in days between two dates in Oracle reports ?

View 2 Replies View Related

SQL & PL/SQL :: Difference Between Dates

Jan 23, 2013

I am looking to subtract two columns and get the difference.

select to_char('06-NOV-2012 20:00','DD-MON-YYYY HH24:MI') - to_char(systimestamp,'DD-MON-YY HH24:MI') from dual;
select to_char('06-NOV-2012 20:00','DD-MON-YYYY HH24:MI') - to_char(systimestamp,'DD-MON-YY HH24:MI') from dual
*
ERROR at line 1:

ORA-01722: invalid number

View 9 Replies View Related

SQL & PL/SQL :: ORA-00923 - Difference Between 9i And 10g

Aug 25, 2010

I encountered this problem when we recently migrated to 10g. The table nametab has two columns roll(number datatype) and name(varchar2(10) datatype).Following are the queries used and I have deliberately not given space between the "select" clause and the "from" clause.

In 9i
SELECT name,1FROM nametab where rownum < 2
NAME 1
---------- ----------
Bharath 1

Same query in 10g
SELECT name,1FROM nametab where rownum < 2
ORA-00923: FROM keyword not found where expected

Here, I have interchanged the select columns.

In 9i
SELECT 1,nameFROM nametab where rownum < 2
ORA-00923: FROM keyword not found where expected

In 10g
SELECT 1,nameFROM nametab where rownum < 2
ORA-00923: FROM keyword not found where expected

View 7 Replies View Related

SQL & PL/SQL :: Difference Between Using MINUS And NOT IN

Sep 28, 2011

I am looking for an explanation for having the following query:

SELECT PK_SERIAL_NUMBER FROM TABLE1 MINUS (SELECT FK_SERIAL_NUMBER FROM TABLE2);

Which normally returns the values of SERIAL_NUMBER that are not passed to the child table TABLE2

and the query:

SELECT PK_SERIAL_NUMBER FROM TABLE1 WHERE PK_SERIAL_NUMBER
NOT IN
(
SELECT FK_SERIAL_NUMBER FROM TABLE2
);

which returns 0 rows!

View 6 Replies View Related

Difference Between V$sql And Dba_hist_sqlstat?

May 30, 2011

1. difference between v$sql and dba_hist_sqlstat?

2. as of i have understood, dba_hist_sqlstat gets refreshed from v$sql.

if i run this below query i get different outputs.. how?

by using v$sql table

WITH t AS
(SELECT force_matching_signature ,
SUM(executions_delta) executions,
COUNT(*) cnt ,
parsing_schema_name ,
MIN(MODILE1) MODULE1

[code].......

View 2 Replies View Related

PL/SQL :: Difference Between 2 Dates

Sep 24, 2012

for the below table

create table RM_TR_INVESTMENT
(
  AS_ON_DT                DATE not null,
  EXP_ID                  NUMBER(10) not null,
  BO_REF_ID               VARCHAR2(30),
  FO_REF_ID               VARCHAR2(30),
  BK_PRODUCT_ID           VARCHAR2(20),
  BK_INV_TYPE_ID          VARCHAR2(20),
 [code]....

I want to find the sum of NP_AMT_CCY where difference between Start_Dt and Maturity_Dt >= 14 days and <=28 days.How can I build the query for the above statement ?

View 6 Replies View Related

SQL & PL/SQL :: How To Get Difference From Hh24:mi

Aug 17, 2013

I have two columns StartTime and EndTIme.

I have data like this

EndTime StartTime Diff(endtime-StartTime)
23:00 20:00 03:00
22:00 21:30 00:30

How can i get Diff(endtime-StartTime) from hh24:mi format

View 2 Replies View Related

Difference Between Database Or SID Upgrade

Oct 19, 2012

i want to know is there any difference between upgradation of SID and database. while upgrading my database from oracle 11.2.0.2 to 11.2.0.3 in DBUA it shows my SID is upgrading (ORCL) but i have few other databases ex (test and prod).

is it enough if we upgrade the SID or we must perform any other actions..

and
2nd QUERY :

i have 2 oracle homes in my server with different versions like (11.2.0.2 and 11.2.0.3)and i have few databases and there tablespaces. how to determine which database is created on which version and which database is upgraded from 11.2.0.2 to 11.2.0.3.

View 3 Replies View Related

Difference Between ADD DISK And ADD VOLUME

May 27, 2013

I have a question about the ADD VOLUME command, I can't understand the difference between ADD DISK and ADD VOLUME.What are the difference between them?When should I use each one?How can I control the stripping and mirroring (NORMAL and HIGH) adding VOLUMES in a DISKGROUP?Can I add a volume to a fail group?

View 1 Replies View Related

Difference Between Coalesce And Defragmentation?

Sep 1, 2012

What are all the differences between Coalesce and De-fragmentation? When i need to use Coalesce?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved