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
ADVERTISEMENT
Oct 22, 2012
query to find out common data from 2 columns in two different tables??
View 6 Replies
View Related
Mar 16, 2011
Now, I am trying to come with an alternative. My first thought was to use materialized views with Fast Refresh - refresh only changed rows. This might not even work because there are many contraints when using Fast refresh. I am in the process of learning their data model so I do not know much.
Have you ever encountered a problem like this?
View 7 Replies
View Related
Nov 8, 2012
Please explain :
What is the difference between : User calls and executes in
AWR Load Profile :
User calls: 1,373.51 0.80
Executes: 8,558.06 4.98
As i understand , than User calls is : the number of DML (insert , update, Delete and Select ) cursor : parse,execute , fetch , and execute is ?
Why executes > User calls ?
Or may be one pl/sql package procedure may execute many SQL ? How to explain this ?
View 2 Replies
View Related
Mar 24, 2011
My Oracle DB 10g R2 running on AIX 5.3 OS. When I am shutting down the oracle I see that it is waiting for complete the active calls and I determined that these active calls/processes are from remote machines.
When I try to run this ps -ef as shown below, it shown me number of oracle process with LOCAL=NO
/home/oracle> ps -ef | grep 91334
oracle 85210 87320 0 12:47:56 pts/35 0:00 grep 91334
oracle 91334 1 0 12:45:11 - 0:00 oracleIDB (LOCAL=NO)
What are the possible scenarios for this LOCAL=NO? How do I find that this process is from which machine or IP address?
View 2 Replies
View Related
Jul 23, 2013
I have a function that is being called three time using UNION and wanted to know if this can be improved to just one call while incorporating all the table joins.
select field1,fdate,fname,username,stepnum from (
SELECT M.FIELD1,
TO_CHAR (M.FIELD_DATE, 'MM/DD/YYYY HH24MISS') AS FDATE,
M.FIELDNAME AS FNAME,
M.USERNAME,
View 10 Replies
View Related
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
View Related
Apr 27, 2010
I have a requirement to calculate the maximum number of concurrent calls from the following data:
Create_date connect_date_time disconnect_date_time duration ...
12/01/10 13:20:26 1263253551 1263254153 602
...
I have attempted to use the analytic function to keep a running total of the count of active calls based on the connect and disconnect times given for each record row.
e.g.
SELECT
count(*) calls,
avg(duration)/60 average_duration_mins,
max(duration)/60 max_duration_mins,
sum(duration)/60 total_mins,
(SUM(DURATION)/60)*0.04 total_cost_4c_per_min
[code]....
View 7 Replies
View Related
Dec 15, 2010
The following query calls the function get_meter_desc 8 times.
SELECT iu.instd_unit_id, iu.fk_cust_id, bill_cd,
iu.mfg_prod_cd, iu.mfg_prod_seq_no, ccequip.fk_mkt_cd,
eff_tmstmp, cust_ord_id, ord_dt, iu.xnac_co_cd,
iu.xnac_div_cd, smmr_wvr_cd, warr_expn_dt,
iu.auto_replen_ind, iu.ms_stat_cd,
inst_dist_id, instn_dt, iu.last_auto_dt,
iu.replen_freq_vlu, cpc_pln_cd, std_sply_ind,
emcv_total_qty, tot_actl_cpy_qty, init_emcv_tot_qty, ms_tran_cd,
[code]...
How can I replace the function call by the join in the main query?
View 19 Replies
View Related
Nov 3, 2011
how to provide the description and parameters of job which calls package on database
package name is some 'xxxxx'
we need to find the job which call the package 'xxxxxx'.
View 2 Replies
View Related
May 8, 2013
Can multiple ODP.NET calls potentially execute within a single Oracle session due to connection pooling?
How can I test/observe this behavior?
We have an IIS application that uses one connection string for all logged in users and call aspx pages.
View 1 Replies
View Related
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
Jul 17, 2012
I am working on the quality center oracle database to write a query that fetches all steps of a test case including the ones having calls to tests. Structure of table is explained below. I've made up an example and attached it as an image to this post. This image also has the expected result of the query I want to write.
Table Name: STEPS (This table contains steps belonging to tests. Some steps are simply calls/links to other tests)
Columns:
STEP_ID (primary key - integer)
STEP_NAME (char)
STEP_DESC (char)
ORDER (integer)
TEST_ID (reference to table TEST.test_id)
[code].......
Referring to the example (see attached image), I'm looking to write a query that gives me all steps (including steps from called tests) of the test - "Empty trash from mailbox" in the correct order.
To start with I can write the following query to get steps of the test - "Empty trash from mailbox".
SELECT * FROM steps WHERE test_id = (SELECT test_id FROM test WHERE test_name = 'Empty trash from mailbox')
View 7 Replies
View Related
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
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
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
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
Feb 27, 2012
what is the most common mode in dataguard? maximize protection or maximize availability or maximize performance
View 6 Replies
View Related
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
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
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
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
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
Dec 13, 2012
Problem is one form that i have to migrate from version 6 throu 6i I got very difficult (for me) error FRM-40734. Happens In WHEN-NEW-FORM-INSTANCE trigger when i try do go_block('NAVI');NAVI block is NOT database block (property set NO)
Database Oracle Database 10g Release 10.2.0.4.0
Forms 11.1.2.0.0,
Below i post some code
When-New-Form-Instance trigger
....some other code
navi_pck.link_activated();
... some other code
navi_pck.Init();
... some other code
Navi_pck is a package added to program modules
PACKAGE BODY navi_pck IS
type t_navi_data is record
( name varchar2(64),
primary_item varchar2(64),
[code]...
When When-New-Instance-Form fires on line navi_pck.link_activated(); we go to init(); in navi_pck packageeverything is ok - that mean it is executed without any errorthen when we hit navi_pck.Init();we got error at Bold line => go_block(g_block); that is error not exception (because adding begin... exception when others ... end; does not catch it)
Of course its needed to be done -> mean that go_block, because after it we clear block and work on it.I got 5 triggers on that block NAVE - but tried already to NULL theirs code but didnt solve the problem (didnt try to remove them...)
View 7 Replies
View Related
Oct 3, 2006
I am using forms 6i. In my program..i am using win_api_dialog.select_printer.I am getting this error frm-40734.
View 5 Replies
View Related
Aug 29, 2011
If i try to execute the below code i go the ora:00600 error. what is wrong in the query.
select FCT.* from (SELECT
NVL(DD.DATE_KEY,1855) AS DATE_KEY,
DP.PRODUCT_KEY AS PRODUCT_KEY,
DP.VENDOR_KEY AS VENDOR_KEY,
DP.VENDOR_CODE AS VENDOR_CODE,
COUNT(DISTINCT FPL.PO_NO) AS PO_ASSIGNED,
SUM(FPL.PO_TOT_QTY) AS UNIT_ASSIGNED,
COUNT(DISTINCT FVL.PO_NO) AS PO_RECEIVED,
SUM(VO_TOT_RECD_QTY) AS UNIT_SHIPPED,
[code]....
View 3 Replies
View Related
Mar 27, 2004
I'm trying to call an help file with the following
BEGIN
Win_API_Shell.WinHelp
('C:eindwerkorainfo.hlp' ,
null ,
WIN_API.HELP_INDEX ,
TRUE );
END;
DK2KWUTIL.pll is attached to the form, info.hlp is an existing file in the path C:eindwerkora.
But it keeps giving me the following error:
FRM-40734: Internal error: PL/SQL error occurred.
View 3 Replies
View Related
Jun 22, 2010
I need a sql/function that formats employee names in Initcap including names with internal capital letters.For example:
Mark VanTassel should be Mark VanTassel and not Mark Vantassel
McGowen should be McGowen
O'Neil should be O'Neil.
found this on the web but didn't quiet understand and didn't work for me.
CREATE OR REPLACE FUNCTION cul_initcap(input_val text) RETURNS text AS
BEGIN
SELECT
REPLACE(
REPLACE(
REPLACE(
REPLACE(
[code]....
View 11 Replies
View Related
Aug 23, 2011
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
DEC OSF/1 AXP Error: 28: No space left on device
View 4 Replies
View Related
May 6, 2013
10g
Our database is hanging with the above error.
I already freed everything in the flash_recovery_area . all archive logs and backupset. But still the error persist :(
I even alter system set recovery desc to 100G. still error.
View 8 Replies
View Related
