PL/SQL :: NOT IN Clause Does Not Work

Oct 4, 2012

with the below example I want to insert new translation in a translation table but the NOT IN clause does not work. I have also tried an ANTI-JOIN after reading much about why the NOT IN might not work but the ANTI-JOIN did not work either.The result of the above query is 0 rows inserted. There are about 1000 rows that do already exist and I want to avoid inserting those again. Note, only the Text is the same not the ID or SOURCE.

INSERT INTO T_Translations
(
     SELECT ID, SOURCE, DOMAIN, TEXT FROM
     (
          SELECT distinct ID, SOURCE, DOMAIN,
          TransText AS TEXT
          FROM (
[code]....

View 3 Replies


ADVERTISEMENT

SQL & PL/SQL :: OrderBy Clause Before From Clause?

Apr 23, 2010

can we use something like this

"select ... order by emp from emp"

what is to be done? so that this qurey runs. no co-related subquery to be used.

View 6 Replies View Related

JavaArch8v3 Work With 11g

May 28, 2013

Can JavaArch8v3 work with Oracle 11g?

View 2 Replies View Related

Text :: How Does ACCUM Work

Jun 21, 2012

how ACCUM works. We are using a text index over XML documents and want to apply a very simple relevance weighting based on occurrences within a certain tag. For example, if TAG1 has a weight of 10, each occurrence in TAG1 should add 10 to the score. We have 13 Tags that should be weighted and multiple occurrences in different tags should be cumulated. So 3 occurrences in TAG1 (weight 10) and one occurence in TAG2 (weight 7) should result in a score of 37.

Just searching in TAG1 works as expected:
( DEFINESCORE( foo, OCCURRENCE ) WITHIN TAG1 ) * 10Three occurrences score 30.

Just searching in TAG2 works also as expected. One occurrence scores 7. However, when I combine both searches
(( DEFINESCORE( foo, OCCURRENCE ) WITHIN TAG1 ) * 10) ACCUM (( DEFINESCORE( foo, OCCURRENCE ) WITHIN TAG2 ) * 7)the score is 61 instead of 37. More interestingly, including all 13 tags (of which most do not contain the search word) lowers the score again.

I ended up with searches where two documents cont

View 7 Replies View Related

XE :: Will 11G Work On 64 Bit Windows Machine

Oct 3, 2012

I would like to down load and install 11g XE beta but I do not know if it will install and run on my 64 bid Windows machine. I had trouble with the 10 G XE trying to down load it on 64 bits.

If I cannot use it on 64 bits could I make it work if I down load Unbuntu Linux? System info as follows:

OS Name     Microsoft Windows 7 Professional
Version     6.1.7601 Service Pack 1 Build 7601
Other OS Description      Not Available
OS Manufacturer     Microsoft Corporation
System Name     XXXXXXXXX (censored)
[code]........

View 1 Replies View Related

SQL & PL/SQL :: What Is The Work Of Owt_text Package

Jun 19, 2013

i just wanted to know what is the work of owt_text package and as well as owt_util package? this package we have to create in database or its in build packages?

View 4 Replies View Related

Backup And Restore Don't Work In Oracle

Mar 22, 2011

I try this for backup:

$ exp scott/tiger FULL=y FILE='d:\demo.dmp';

and this for restore:

$ imp scott/tiger FULL=y FILE='d:\demo.dmp';

and after restore i can't see the data in my tables. (i work on Oracle 11.2.0 64bit)

View 2 Replies View Related

SQL & PL/SQL :: Oracle Procedure Doesn't Work On Web

Jul 28, 2010

I was working on an applications program It is written in PL/SQL . It is running on an oracle 8i database It was not written by me but now I am responsible of it. I made some changes to database tables for this years regulations. Everything was working fine but yesterday I have recompiled two of the packages for some regulations and one of the procedures was stopped working.

It is called 'sayfa2'. Packages names are 'aday1' and 'aday2'. They both have a procedure called sayfa2 and both of them don't work now. They gave me no compilation errors. All I did is I have copied the original code from toad and compiled it at sqlplus I have changed nothing except some texts inside html tags. I couldn't guess what is wrong.

It actually converts to html pages. All procedures are working fine except sayfa2. aday1 is for to fill information and submit but when I click submit button it gives an error:

The requested URL /pls/kon/aday1.sayfa1 was not found on this server. Oracle HTTP Server Powered by Apache/1.3.19 Server at ...

There is also a problem with Turkish characters they don't appear correctly.

Below is sayfa2 and I also added aday1 package could you have a look at it .

PROCEDURE sayfa2(stuid VARCHAR2,tckimlik VARCHAR2, ad VARCHAR2, ad2 VARCHAR2, soyad VARCHAR2,
sex VARCHAR2, mdurum VARCHAR2, bad VARCHAR2, aad VARCHAR2,
dyer VARCHAR2, dgun VARCHAR2, day VARCHAR2, dyil VARCHAR2,
nil VARCHAR2, nilce VARCHAR2, nkoy VARCHAR2, cilt VARCHAR2,
asira VARCHAR2, sira VARCHAR2, asuba VARCHAR2, kang VARCHAR2, agorev VARCHAR2,
[code].......

View 10 Replies View Related

Forms :: How To Work Without Opening OC4J

Jun 13, 2010

How to work on forms without opened oc4j..

am working on 10G .. Forms 10G

am using the OC4J for the oracle FORMS 10G to me the engine for woring maybe about 20 client ..

my question :

1- if am close the OC4j the forms closed ?
2- how to work forms to be like off line if the oc4j is closed and working tell before save .. ?

View 3 Replies View Related

Client Tools :: How To Work With SQL From Home PC

Feb 16, 2012

I want to practice Oracle SQL from home.What software i need to install. Even if i install SQL developer,SQL+ which database i can access n how.

View 10 Replies View Related

SQL & PL/SQL :: Can Auto Extend Work With Quota

Apr 9, 2012

I have given a specific user default tablespace on Users and a quota 5M. However I want to check if the user have used up 70% of that 5M. If so, I want to increase quota by 500K so in this will be an additional to the 5M. The code I wrote is overwriting the 5M I initially gave the user with 500K. Attached is a sample of the code.

View 14 Replies View Related

Forms :: Go_block Doesn't Seem To Work?

May 7, 2013

I have a master block (MASTER with Item 1 and 2) and details block (DETAILS). If the user enters the query mode and queries the Master block, the Details get populated automatically. So far so good.

Now I attached an LOV to Item 1 in the Master Block and the requirement is that when the user picks an item in the LOV, the details should automatically populate. Because of "restricted procedures" (GO_BLOCK) in triggers, I put a Button in a Control Data Block and the code in the WHEN-BUTTON-PRESSED trigger is as follows :

GO_BLOCK('DETAILS');
EXECUTE_QUERY;

It does go to the Details block and also displays all the details. However, when I try to update, insert or delete data, it fails with "Insufficient Privileges". So when I looked at the query being executed (Cntrl + Shift + E), I can see that it is trying to perform these operations on the Master block. (ie for some reason the scope is still in the Master and not Details even after Go_Block(DETAILS) has been executed.

I then tried to use Go_Item('DETAILS.Dept_No') to see if that would work. That too did not work. I tried to set the Navigation Style on these Data Blocks to "Change Data Block". Still no success.

View 3 Replies View Related

Forms :: Set_menu_item Property Not Work

Jun 6, 2010

The code on menu item is UnVisible_Menuitem('ITEM193');

Menu procedure is

PROCEDURE UnVisible_Menuitem( menuitem_name VARCHAR2) IS
mi_id MenuItem;
ALT NUMBER;
BEGIN
mi_id := Find_Menu_Item( menuitem_name );
[code]...

i try it for the both visible and non-visible items but it dosnt work.

View 1 Replies View Related

SQL & PL/SQL :: How Does Oracle Sequence Work Internally

Sep 26, 2011

how does a oracle sequence work internally ?

View 1 Replies View Related

SQL & PL/SQL :: Escape Sequence Didn't Work

Dec 30, 2011

I'd like to use escape sequences in plsql but it didn't work.I have to use a variable 'v_jahr'..This is what I like to do:

SELECT COUNT(TABLE_NAME) FROM USER_TABLES
WHERE TABLE_NAME = 'TABLE' || v_jahr;

But I think I should use an 'EXECUTE IMMEDIATE' like this:

EXECUTE IMMEDIATE 'SELECT COUNT(TABLE_NAME) FROM USER_TABLES
WHERE TABLE_NAME = 'TABLE' || v_jahr';

But then I have to escape my tics. How can I do this?

I tried this:

EXECUTE IMMEDIATE 'SELECT COUNT(TABLE_NAME) FROM USER_TABLES
WHERE TABLE_NAME = '||''''||'TABELLE_'||'''' || v_jahr ||'''';

View 3 Replies View Related

Reports & Discoverer :: Will The SRW.MESSAGE Work In 10g

Sep 29, 2010

Will the SRW.MESSAGE work in Report 10g? what command has to be used?

View 1 Replies View Related

PL/SQL :: Why TRUNCATE Command Would Not Work In Block

Sep 10, 2012

Why the TRUNCATE command would not work in PL/SQL block ? A work arround would be dynamic SQL, but I'm avoiding it...

begin
truncate table test;
end;

View 7 Replies View Related

How Does Local Index Work In Partitioned Table

Nov 28, 2012

I have table with 4 partition by range partition. I am loading the table in bulk mode to latest partition. Before I load , I dropped the index and after Load I will be creating index. So when I am dropping index, it is dropping index from all the partitions and when creating the index, I am creating the index for all partitions. When I am creating index using local, it is telling you have to create local index for all partitions at the same time. because of that I have to drop and recreate all indexes again. Again I have to gather stats for whole table .

I was thinking we can build index for one partition and index should remain as is for old partitions If this is not the case, how do I plan my load for a partitioned table using bulk mode to latest partition.

View 4 Replies View Related

Enterprise Manager / Unable To Work On Windows?

Apr 21, 2011

I attempt to log to the Enterprise Manager via --> [URL] but I only receive the 'Page not found' error

As this is on a windows server I attempt to restart the service to no avail Also I try to start emctl start dbconsole - whcih also does not work

The Listener is up and running

If I issue a emctl status oms - I receive error Oracle Enterprise Manager 10g Grid Control not installed. Request Ignored.

with --> emctl status dbconsole

output is Oracle Enterprise Manager 10g is not running.

Logfiles:

Logs are generated in directory D:\oracle\product\10.2.0\db_1/ukedgas71.pcroot.com_OEMREP/sysman/log

Logfiles:

Directory of D:\oracle\product\10.2.0\db_1\UKEDGAS71.pcroot.com _OEMREP\sysman\log

20/04/2011 15:06 10,297 emagent.log
05/06/2009 09:48 0 emagentfetchlet.log
05/06/2009 09:46 0 emdctl.log
20/04/2011 15:05 6,363,995 emoms.log
20/04/2011 15:14 29 OracleDBConsoleOEMREPexit.log
20/04/2011 15:14 188,284 OracleDBConsoleOEMREPsrvc.log
05/06/2009 09:46 4,383 secure.log
7 File(s) 6,566,988 bytes

Tracefiles:

Directory of D:\oracle\product\10.2.0\db_1\UKEDGAS71.pcroot.com _OEMREP\sysman\log

20/04/2011 15:14 1,418,777 emagent.trc
05/06/2009 09:48 0 emagentfetchlet.trc
28/11/2009 16:21 8,360 emagent_perl.trc
21/04/2011 11:12 2,060,670 emdctl.trc
20/04/2011 15:05 1,649,464 emoms.trc
5 File(s) 5,137,271 bytes
0 Dir(s) 3,274,207,232 bytes free

View 14 Replies View Related

SQL & PL/SQL :: Grant Privileges To Subprogram Via Role - Should Not Work

Jun 8, 2010

I bought Selftestsoftware for 1z0-147 for 9i and 10g. Selftestsoftware is endorsed by Oracle, should be high quality.

But its below sample question and answer seem to be wrong: It says that privilege for subprogram can be granted via role. But from Urman 9i book: the grant the execute privilege must be done explicitly and not through a role.

Did Selftestsoftware made a mistake? Or the question did not mention or assume that the subprogram is based on invoker rights not definer right?

Quote:
Question: All users in the HR_EMP role have UPDATE privileges on the EMPLOYEE table. You create the UPDATE_EMPLOYEE procedure. HR_EMP users should only be able to update the EMPLOYEE table using this procedure. Which two statements should you execute? (Choose two.)

GRANT UPDATE ON employee TO hr_emp;
GRANT SELECT ON employee to hr_emp;
REVOKE UPDATE ON employee FROM hr_emp;
REVOKE UPDATE ON employee FROM public;
GRANT EXECUTE ON update_employee TO hr_emp;

Explanation:
The two statements you should execute are:
REVOKE UPDATE ON employee FROM hr_emp;
GRANT EXECUTE ON update_employee TO hr_emp;

Unless you are the owner of the PL/SQL construct, you must be granted the EXECUTE object privilege to run it or have the EXECUTE ANY PROCEDURE system privilege. By default, a PL/SQL procedure executes under the security domain of its owner. This means that a user can invoke the procedure without privileges on the procedures underlying objects. To allow HR_EMP users to execute the procedure, you must issue the GRANT EXECUTE ON update_employee TO hr_emp; statement. To prevent HR_EMP users from updating the EMPLOYEE table unless they are using the UPDATE_EMPLOYEE procedure, you must issue the REVOKE UPDATE ON employee FROM hr_emp;

All of the other options are incorrect because they will not meet the specified requirements.

View 7 Replies View Related

Forms :: How To Make Query Mode Work (f11)

Apr 2, 2012

I have created a custom form. I have field called Order No. When i query on Order no.. i should be able to pick order no as well as other fields related to it. how do i acheive this functionality. I mean the f11 and ctrl f11 querying functionality.

View 18 Replies View Related

Possibility To Implement LDAP At Place Of Work

Nov 17, 2010

We are looking at the possibility to implement LDAP at my place of work. Anything we should look for of not doing or doing to make this work?

View 1 Replies View Related

SQL & PL/SQL :: Create A Table With Column Name As UID But UID Doesn't Work

Jan 11, 2011

It shows me error when i create a table with column name as UID.

Is UID a inbuilt function or anything else?

View 2 Replies View Related

Localhost Doesn't Work In Listener.ora Or Tnsnames.ora

Jul 29, 2010

I want to be able to use "localhost" in my tnsnames.ora and listener.ora files but for some reason its not working.

just concentrating on the listener, when I have the following in my listener.ora the database doesnt register with the listener:

########################################
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))))
########################################

This is even after using the "alter system register" command. I'm checking whether my database is registering using "lsnrctl services".

With the following in listener.ora all is fine:

########################################
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.152)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))))
########################################

So why wont it work with localhost?! I'm running Oracle 11G on XP Pro.

View 7 Replies View Related

PL/SQL :: Foreign Key Can Be Implemented In One Table And Cannot Be Duplicated To Work

Oct 17, 2013

I have now  created my tables and now I want to populate them with my data but I get errors below is my full sql command. From last time I learned that one foreign key can be implemented in one table and cannot be duplicated to work around this I changed my foreign key as you can see to "fkone" . but why am I getting errors when trying to add information I mean I have not gotten errors in the first two tables so what am I "doing wrong/ not understanding" 

CREATE TABLE CUSTOMER (CUSTOMERNAME varchar (25),STREET varchar (25),CUSTOMERCITY varchar (25),CONSTRAINT CUSTOMER_pk PRIMARY KEY (CUSTOMERNAME)); CREATE TABLE DEPOSIT (CUSTOMERNAME varchar (25),BRANCHNAME varchar (25),ACCOUNTNUMBER int,BALANCE decimal (7,2),CONSTRAINT DEPOSIT_pk PRIMARY KEY (ACCOUNTNUMBER)); CREATE TABLE LOAN(CUSTOMERNAME varchar (25),BRANCHNAME varchar (25),LOANNUMBER int,AMOUNT decimal (7,2),CONSTRAINT LOAN_pk PRIMARY KEY (LOANNUMBER)); CREATE TABLE BRANCH (BRANCHNAME varchar (25),BRANCHCITY varchar (25),ASSETS decimal (7,2) ,CONSTRAINT BRANCH_pk PRIMARY KEY (BRANCHNAME)); ALTER TABLE DEPOSITadd
[code]....

View 4 Replies View Related

Forms :: Not Saving - Validation On Age Doesn't Work?

Mar 8, 2011

im now doin' my currently program, actually they requesting for an update. I added birth date column in the module,they asked to the request to put a validation on date, such as:

a. under age
b. :txt_ph_birthdate > SYSDATE
c. if :txt_plan_type = 212 then
17 yrs, 5 mos and 29 days and 40 yrs, 5 mos and 29 day - as validation
d. if :txt_plan_type = 214 then
40 yrs and 6 mos and 55 yrs, 5 mos and 29 days - as validation
e. if :txt_plan_type = 215 then
17 yrs, 5 mos and 29 days and above - as validation

they also instructed me to put the validations in birth date after the column of birthdate, which is the :txt_plan_type(list_item) and i put it in TRIGGER (when-validate-item)after i did the codes and compile it., theres no message for error but i think its not working..it working. i already updates also the insert and the other trigger and procedure, i just add the plan type on it.

i havent edit the save button because the as i read the codes the it just call the procedure that i edit.when i run the program and after i encode the data..and when i press the save button, nothing happens or any confirmation.in addition, why is it that my validation on age doesnt work?

heres the

declare
n_months_between NUMBER;
d_same_day_occur DATE;
n_years NUMBER;
n_months NUMBER;

[code]...

View 8 Replies View Related

How Streams Export / Import Parameters Work

Nov 30, 2011

I have a test database with tables that occasionally has to be updated to the state of the production database tables. These databases both stream several tables to separate databases. (ie database A streams tables to database X and B to Y).

I export the needed schema daily from the production database "A". To update the test database "B", I import the needed tables from this export file. I then export the tables to be streamed from database B with the object_consistent=y parameter. I then import those tables to database Y using the streams_instantiation=y parameter.

So this is the process ...

1. Turn off capture on B
2. Turn off apply on Y
3. Drop the tables in B
4. Import tables from A to B
5. Prepare instantiation on tables in B (DBMS_CAPTURE_ADM.PREPARE_TABLE_INSTANTIATION)
6. Export from B with object_consistent=y
7. Drop tables in Y
8. Import from B to Y with streams_instantiation=y
9. Start apply on Y
10. Start capture on B

I ran this overnight through an OEM job and it appeared to work, just not how I expected. When I came in there was a lot of activity on both databases. All sessions were from the streams admin account. This continued for some time (long after the job had finished). During this time the "captured scn", "applied scn" & "last enqueued scn" values were quite different on the source side (didn't jot those down). I compared these ot the "last applied message number" on the target side and the valuse were quite a bit off.

After the activity subsided, the SCN values were all in the same ballpark. So I figure all the activity was changes getting applied from database B to database Y. I tested out the streaming and it's working fine.

I thought the parameters in the export and import statements were supposed to sync up the SCNs. That is I thought they would start off in the same state and there would be no need for applying changes. No one changed anything on the source database overnight.

I must not be understanding how the streams export/import parameters work.

View 5 Replies View Related

Application Express :: Setting Up SSO In Work Area?

Jul 5, 2012

How to set up Apex SSO in your work area? I have been trying to set it up, but to no avail. I even tried asking support but still under oblivion.

Have you able to run this script before?

apex_sso.sql, apex_verify.sql, apex_sso_server.sql

My output for this scripts are good.

View 0 Replies View Related

How To Rewrite MSSQL Update Statement To Work In Oracle

Dec 29, 2011

How do I write this MSSQL statement so it works in Oracle?

update b1
set b1.b1_app_status = r3.application_status
from conv_app_status_update a, statyp r3, b1perm b1
where a.spc = r3.serv_code
and a.task_des = r3.r3_act_type_des
and a.task_status =r3.r3_act_stat_des
and a.process_code = r3.r3_process_code
and r3.application_status is not null
and a.spc = b1.serv_code
and a.id1 = b1.id1
and a.id2 = b1.id2
and a.id3 = b1.id3

View 1 Replies View Related

Windows :: Oracle 11g R2 Install On 7 64 Bit Setup EXE File Does Not Work

Jul 5, 2010

I am trying to install Oracle 11g R2 on my Windows 7 Ultimate 64 bit. When I execute setup.exe as Administrator the command window flashes and exits. I could not even see what the message is. Also tried command prompt.

View 12 Replies View Related







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