Difference Between Database Modelling And Designing
Apr 29, 2013What is the difference between Database Modelling and Database Designing ?
View 5 Replies
ADVERTISEMENT
SQL & PL/SQL :: Designing A Query - Who To Loop Through Process
Jul 22, 2011i have query which scores a customer details on some factors and gives it a rank/I have a table called agents which holds the agents details.
This is how i get the rank:
select *
from (
select customer_name ,agent_number
[code]....
The agents table has agent_number and agent_Name....By the above query i check various score against all available agents and assign customers to agents who have highest score or rank is 1
But my problem is who to loop through the process.. i mean after the intial customers are assinged with agents it should run again for remaining customers and for agents who are free(and rank for them is 1) should be checked for assignment Once all agents are assigned but still more customers are available then agents even thoug they are already assigned they can be assigned now since no agent is free..
Forms :: Designing DB Application - Button Trigger?
Mar 23, 2012i'm designing a DB_application where a user makes certain subject selections depending on what grades they have. so far ive made simple signin form as follows....
Create table Persons(
person_id number(8) constraint pk_Persons primary key,
person_pword varchar2(16) not null;
declare
user_id number(8);
user_pword varchar(16);
alert_button number;
begin
[code]...
now the next step... that SIGNED IN user is taken to a menu with links to select their topics or units. HOWEVER only a PARTICULAR link can be followed depending on what grade they've achieved in a NECESSARY UNIT for example to do advanced maths u need beginners maths = PASS. if = fail then user cannot proceed. heres my sql as well as the trigger ive made an attempt at...
Create table Grades(
grade_code number constraint pk_Grades primary key,
grade varchar(4) check (result in ('fail','pass')),
person_id number,
unit_code number,
CONSTRAINT fk_Persons FOREIGN KEY (person_id) REFERENCES Persons (person_id),
[code]...
i know my second trigger is poorly designed and lacking.
PL/SQL :: Difference Between Install Database And Create Database?
Jan 11, 20131.what is the difference between install database and create database?
2. if i have connected with remote database(server) then it is an instance again?
Difference Between Database Or SID Upgrade
Oct 19, 2012i 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.
RAC & Failsafe :: Difference Between RAC And Non-RAC Database
Sep 13, 2012Tell me the difference between Oracle RAC and Non RAC database including commands and architecture?
View 4 Replies View RelatedDifference Between Auxiliary And Target Database
Nov 15, 2010I want clear the concept of auxiliary database. What's the use/advantages of it. Is it the another oracle instance? What is the difference between Auxiliary Database and Target Database?
View 3 Replies View RelatedWindows :: Difference Between Standby And Clone Database
Aug 19, 2011Difference of standby and clone,i know their uses but i want a detailed explanation.
View 2 Replies View RelatedDifference Between Oracle Database Server And Client?
Jul 22, 2011Currently 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?
SQL & PL/SQL :: Difference Between File Catproc That Run After Creation Of Database In Oracle 9i /10g / 11g R2
Aug 18, 2010I 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 RelatedBackup & Recovery :: Difference Between Flashback Database And Incomplete Recover
Jul 23, 2012What is difference between the flashback database(10g later) and incomplete recover?
View 5 Replies View RelatedRMAN :: Difference Between Recover Database And Alter Database Recover?
May 9, 2013Oracle database 11.2
What is the difference between
recover database until cancel using backup controlfile; and alter database recover automatic until cancel;
1. in user managed and server managed backups. What would be the location of the controlfile which is used in (recover database until cancel using backup controlfile;) .
2. why user first option and why use second option.
Networking And Gateways :: Oracle 11gR2 Database - Performance Difference Between Windows PC And On VMware
Feb 9, 2012We 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.
PL/SQL :: Calculate Difference By Which Day Count Of Difference Is Going?
Oct 17, 2012Detail 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?
Installation :: Oracle Database Express And Other Editions Installation Doc Difference?
Mar 20, 2013My 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?
SQL & PL/SQL :: Get Max Difference Where Each Value Can Look At Only Next?
May 28, 2013How 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]....
How To Get Date Difference
Jul 20, 2007How one can get date difference in days between two dates in Oracle reports ?
View 2 Replies View RelatedSQL & PL/SQL :: Difference Between Dates
Jan 23, 2013I 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
SQL & PL/SQL :: ORA-00923 - Difference Between 9i And 10g
Aug 25, 2010I 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
SQL & PL/SQL :: Difference Between Oracle 9i And 10g?
Apr 25, 2013what are difference in between oracle 9i and 10g regarding with Sql queries?
View 1 Replies View RelatedSQL & PL/SQL :: Difference Between Using MINUS And NOT IN
Sep 28, 2011I 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!
Difference Between V$sql And Dba_hist_sqlstat?
May 30, 20111. 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].......
SQL & PL/SQL :: Difference Between Oracle 8i And 11g
Sep 22, 2011I 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.
PL/SQL :: Difference Between 2 Dates
Sep 24, 2012for 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 ?
PL/SQL :: Difference Between Oracle DB 11.2.0.1.0 And 11.2.0.3.0?
Dec 18, 2012When 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?
SQL & PL/SQL :: How To Get Difference From Hh24:mi
Aug 17, 2013I 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
Difference Between ADD DISK And ADD VOLUME
May 27, 2013I 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 RelatedDifference Between Coalesce And Defragmentation?
Sep 1, 2012What are all the differences between Coalesce and De-fragmentation? When i need to use Coalesce?
View 4 Replies View RelatedDifference Between Oracle Version 10.2.0.3 And 10.2.03?
May 28, 2008difference 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.
Difference Between Number And String?
Oct 20, 2012I can't understand >>
1. Number 2 is less than number 100,
2. string '2' is greater than string '100'.
>> Numbers are ordered by numerical value; strings are ordered by alphabetical value. >>