SQL & PL/SQL :: How Does Oracle Sequence Work Internally
Sep 26, 2011how does a oracle sequence work internally ?
View 1 Replies
ADVERTISEMENT
SQL & PL/SQL :: Escape Sequence Didn't Work
Dec 30, 2011I'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 ||'''';
Backup And Restore Don't Work In Oracle
Mar 22, 2011I 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)
SQL & PL/SQL :: Oracle Procedure Doesn't Work On Web
Jul 28, 2010I 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].......
How To Rewrite MSSQL Update Statement To Work In Oracle
Dec 29, 2011How 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
Windows :: Oracle 11g R2 Install On 7 64 Bit Setup EXE File Does Not Work
Jul 5, 2010I 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 RelatedPrecompilers, OCI & OCCI :: Keep Connected To Oracle Or It's Better Reconnect After Work?
Feb 27, 2012I'm a beginner in the PRO*C and I have this issue/I have to maintain a multithreaded C++ PRO*C application and has the following structure
1) Application runs waiting for requirements
2) When detects a requirement it creates a Thread to work
3) The thread connects to Oracle with a EXEC SQL CONNECT :uid IDENTIFIED BY :pwd; instruction
4) Calls some anonymous calls to execute a stored procedure
EXEC SQL EXECUTE
BEGIN
commit;
:Status:=stored_procedure(:param1, :param2);
commit;
END;
END-EXEC;
5) If anything went wrong then issues a EXEC SQL ROLLBACK WORK RELEASE; then reconnects and the thread die
6) If everything was OK then the thread dies, but never called a EXEC SQL COMMIT WORK RELEASE; to disconnect from Oracle
I don't know why never the application disconnects from Oracle, maybe is for performance. Sometimes the application crashes and I believe that maybe the error is for never freeing the connections, the PROC compile line is this
proc parse=full sqlcheck=full user=system/manager cpp_suffix=cpp iname=source.pc include="..Hdr" include="C:ORACLEORA81ociinclude" include="C:ORACLEORA81precomppublic"
Which is the way to implement the connections?, connect and disconnect when done? or just keep the connection alive? Which way has better performance, connect and disconnect or just keep the opened connection?
Oracle 11g Installation - SYSTEM Admin Password Does Not Work
Aug 13, 2012I have installed oracle several times in the past. This time I installed 11gr2 first time. I created default database during install and provided an admin password. Only thing I forgot to do was did not unlock the accounts using Password management button.
When I tried to login as SYS the admin password works fine but as SYSTEM admin password does not work. Used to be able to login as SYS, SYTEM with same admin password.
Now in SQLPLUS I unlocked the account but still can not change the password.
Client Tools :: Does Toad 8.5 Work With Oracle 10gr Database
Jul 7, 2010We plan to migrate the databases to Oracle 10gR2 from Oracle 9i. know whether Toad 8.5 works fine with Oracle 10gR2 or not?
View 4 Replies View RelatedServer Administration :: Database Configuration Assistant Doesn't Work Oracle 8.0.5
Mar 28, 2010I've installed without problems Oracle 8.0.5 on WS 2003. After installation I've created 8 databases, with the utility Database Configuration Assistant (dbassist, executed by launch80.exe).
After that, the DBAssist doesn't run anymore.
I've tried EVERYTHING. And I have no success, Im stuck. And I need to create several databases.
SQL & PL/SQL :: Oracle Primary Key Error On Sequence Number Generator
Mar 11, 2011I have a table called table 1 and I am trying to insert a few values in this table and i am constantly getting bogged down by a primary key error. Strange thing is this primary key called "ID" on the table is a system generated sequence value number. The error is
"ORA-00001: unique constraint (Schema1.LICN_PK) violated"
Table structure:
*****************************************
CREATE TABLE schema1.table1
(
ID NUMBER(12),
LITM_ID NUMBER(12),
PROG_PROGRAM_CD VARCHAR2(2 BYTE),
SCHED_NBR VARCHAR2(3 BYTE),
SCHD_VERSION_YR NUMBER(4),
SCHD_VERSION_NBR NUMBER(3),
[code]........
****************Insert statement*************
insert into table1
(id,
litm_id,
prog_program_cd,
sched_nbr,
schd_version_yr,
[code].......
why the error is coming up and any way to resolve it. I checked the max sequence number value and kept running it for a while and then tried to run my insert statement but no luck yet.
Reports & Discoverer :: Sequence Number In Oracle 10gR1
Aug 26, 2010My requirement is I have to get a sequence no generated for 2 set of groups. Here is an example to better resolve it.
Gr1
Seq Data
--------------
1 Data1
2 Data2
3 Data3
GR
Seq Data
--------------
4 Data1
5 Data2
JavaArch8v3 Work With 11g
May 28, 2013Can JavaArch8v3 work with Oracle 11g?
View 2 Replies View RelatedPL/SQL :: NOT IN Clause Does Not Work
Oct 4, 2012with 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]....
Text :: How Does ACCUM Work
Jun 21, 2012how 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
XE :: Will 11G Work On 64 Bit Windows Machine
Oct 3, 2012I 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]........
SQL & PL/SQL :: What Is The Work Of Owt_text Package
Jun 19, 2013i 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 RelatedForms :: How To Work Without Opening OC4J
Jun 13, 2010How 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 .. ?
Client Tools :: How To Work With SQL From Home PC
Feb 16, 2012I 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 RelatedSQL & PL/SQL :: Can Auto Extend Work With Quota
Apr 9, 2012I 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 RelatedForms :: Go_block Doesn't Seem To Work?
May 7, 2013I 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.
Forms :: Set_menu_item Property Not Work
Jun 6, 2010The 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.
Reports & Discoverer :: Will The SRW.MESSAGE Work In 10g
Sep 29, 2010Will the SRW.MESSAGE work in Report 10g? what command has to be used?
View 1 Replies View RelatedPL/SQL :: Why TRUNCATE Command Would Not Work In Block
Sep 10, 2012Why 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;
Sequence Name In Oracle Database Schema As Well As Timesten Schema?
Jan 13, 2011How to use same oracle sequence name in Oracle Database schema as well as timesten schema?
View 1 Replies View RelatedHow Does Local Index Work In Partitioned Table
Nov 28, 2012I 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.
Enterprise Manager / Unable To Work On Windows?
Apr 21, 2011I 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
SQL & PL/SQL :: Grant Privileges To Subprogram Via Role - Should Not Work
Jun 8, 2010I 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.
Forms :: How To Make Query Mode Work (f11)
Apr 2, 2012I 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 RelatedPossibility To Implement LDAP At Place Of Work
Nov 17, 2010We 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