SQL & PL/SQL :: Getting Most Common Value

Mar 31, 2010

I am using this query:

Select
t1.col1 as A,
t2.col1 as B,
t3.col1 as C,
t4.col1 as D

[Code]...

with this above query i am getting result like this:

A B C D

2 null 2 null
6 6 null 6
8 null null null

However i need the result like this:

A B C D

6 6 null 6

Note:

I am looking for common value that presents in most of these 4 tables for different t1.col2 values like 'E','G','K',...etc. I cant use the NOT NULL condition in the where clause,since i need to check for different values in t1.col2,for each of this there may be null value in any of the 4 tables.

View 3 Replies


ADVERTISEMENT

SQL & PL/SQL :: How To Get Common Records

Feb 10, 2013

I have a situation as follows.

Table1 has 10 columns as col1,col2,col3,col4,...col10

Table2 has 5 columns as col1,col2,...col5.

col3 and col4 are common in both tables.I am trying to get common records from both tables.How can I get them.

View 3 Replies View Related

SQL & PL/SQL :: How To Use Common Group By Function While Using Union All

Aug 12, 2010

i am having two sql query which i have made union of it but i need group by common.

select
distinct ac.CUSTOMER_NAME cust_name,
ac.CUSTOMER_NUMBER cust_no,
ps.CUSTOMER_SITE_USE_ID,
raa_ship_ps.PARTY_SITE_NAME loc,
sum(days_30.AMOUNT_DUE_REMAINING) D_30,

[code]........

View 9 Replies View Related

SQL & PL/SQL :: How To Calculate Highest Common Factor

Oct 5, 2005

Is there any function avaialble in SQL that can return the highest common factor among a bunch of numbers. For example
10,20,25 have a highest common factor of 5.

View 9 Replies View Related

SQL & PL/SQL :: Grouping List Of Elements With One Or More Common?

Oct 6, 2011

I have a one column table that store lists of elements :

create table test_table (c1 VARCHAR2(4000));
insert into test_table values ('1,23');
insert into test_table values ('1,2');
insert into test_table values ('3,4,5');

[code]...

The output column would be something like that:

output_column
1,2,7,23
6,9,0
3,4,5

I'm grouping columns that have at least one element in common.

(1,23) and (1,2) merge into : (1,2,23)
(1,2,23) and (7,2) merge into : (1,2,7,23) --> Output
(6,9) and (9,0) merge into : (6,9,0) --> Output
(3,4,5) and (5,5) merge into : (3,5,5) --> Output

I have made this logic using only PL/SQL, with loops and nested tables using function memberof, but I suppose that there is a way to improve the performance using only SQL.

View 9 Replies View Related

Forms :: Host Common On Linux

Oct 27, 2010

My database as well as application on linux. I want to execute this command on linux. I need equivalent code.

host('cmd /c E:data empITC1'.bat');

code of ITC1.bat is
echo off
sqlldr userid=user_name/pass@database control=E:data empITC1.ctl log=E:data emplogITC1.log

echo ........

control file as well as bat file exist in respective folders.

View 9 Replies View Related

Data Guard :: What Is The Most Common Mode

Feb 27, 2012

what is the most common mode in dataguard? maximize protection or maximize availability or maximize performance

View 6 Replies View Related

PL/SQL :: Find Common And Internal Calls?

Jul 19, 2013

create table call(id number(15) primary key, calling_no varchar2(15), called_no varchar2(15), calldate date, calltime timestamp, duration number(10) ,calltype varchar2(10));  1. CALL DETAILS OF 9891826547insert into call (id,calling_no,called_no,calldate,calltime,duration,calltype) values (1, 9891826547, 9891210785, to_date('01-Jun-13','dd-Mon-yy'), to_date('19:12:00','hh24:mi:ss'),10,'OUT'); insert into call (id,calling_no,called_no,calldate,calltime,duration,calltype) values (2,9891826547, 9899985476, to_date('01-Jun-13','dd-Mon-yy'), to_date('22:10:12','hh24:mi:ss'),50,'OUT'); insert into call (id,calling_no,called_no,calldate,calltime,duration,calltype) values (3, 9891826547, 9818415767, to_date('02-Jun-13','dd-

[code]...

View 3 Replies View Related

PL/SQL :: Find Common Data In 2 Columns In Two Different Tables

Oct 22, 2012

query to find out common data from 2 columns in two different tables??

View 6 Replies View Related

74 Privileges From Different Users On Different Tables To One Common User?

May 20, 2013

i have to give 74 privileges from different users on different tables to one common user,how can i do this?

View 7 Replies View Related

SQL & PL/SQL :: Oracle 11g / Windows 8 - Common Code In Package

Sep 13, 2013

In oracle 11g windows8 - OS

Suppose, there is a package p1 with proc A, Proc B and Func C.Now when any of the package proc or func gets invoked from a stored proc G then a common code which reads the cols of table xyz should be executed. How to do that?

View 8 Replies View Related

PL/SQL :: Compare Two Tables And Delete The Common Rows From Table 1

Jul 23, 2012

I want to compare two tables , and delete the common rows from the first table

Here is what i have done :

Create table test1(Test1C1 Number,
Test1C2 varchar2(50));

Create table test2(Test2C1 Number,
Test2C2 varchar2(50));

Insert into test1 values(1,'testdata1');
Insert into test1 values(2,'testdata2');
Insert into test1 values(3,'testdata3');
[code].......

it deletes all the records from Table test1. What should I modify here ? or should I write a different query ?

The desired contents in table test1 will be

2 testdata2
4 testdata4
6 testdata6
8 testdata8
10 testdata10

View 5 Replies View Related

Application Express :: How To Validate In Common PL/SQL Package And Show Custom Messages

Feb 11, 2013

Currently if i let required field empty, then APEX puts systematic error message "XXX must have some value." near the field and into the page header. I want to create custom business rule, that would show message for example "This action cannot be performed, because this and that...".

That kind of custom validation should be in my plSql package and somehow it should throw/send the phrase "This action cannot be performed, because this and that..." to the page header where was message "XXX must have some value.".

How can i create such custom error message to appear out using PlSql package function that i define myself? I plan to create a common validation package, which has lots of plsql functions to validate lot of APEX pages/forms, all those functions should throw/send somehow error messages to page header. I looked that this unofficial solution does not suit for me:

[URL].......

Because it disables APEX systematic automatic validations as i understand, and is unofficial.

View 4 Replies View Related

Forms :: PDE-PLI011 A Tools Common Schema Table Missing From Object Store

May 26, 2011

while trying to open an exisitng Form, an Error message appears as:

PDE-PLI011 A tools common schema table is missing from the object store.

and failed to open. what's the problem ? what i have to do ? it was working fine before.

View 2 Replies View Related







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