What you’ve run into is the classic “mutating table” exception. In a ROW trigger Oracle does not allow you to run a query against the table which the trigger is defined on – so it’s the SELECT against TABLE1 in the DELETING part of the trigger that’s causing this issue. There are a couple of … Read more
Either: The database isn’t running You got the URL wrong There is a firewall in the way. (This strange error message is produced by Oracle’s JDBC driver when it can’t connect to the database server. ‘Network adapter’ appears to refer to some component of their code, which isn’t very useful. Real network adapters (NICs) don’t … Read more
I know 17 ways to connect to an Oracle Database from a .NET application. ODBC with driver from Oracle var connectString = “Driver={Oracle in OraClient11g_home1};Uid=scott;Pwd=secret;DBQ=orcl1”; var con = new System.Data.Odbc.OdbcConnection(connectString); con.Open(); (exact driver name Oracle in OraClient11g_home1 depends on installed Oracle version) ODBC with driver from Microsoft (only for 32bit, deprecated, does not work anymore … Read more
If you want just a first selected row, you can: select fname from MyTbl where rownum = 1 You can also use analytic functions to order and take the top x: select max(fname) over (rank() order by some_factor) from MyTbl
Assuming a Windows installation, do please refer to this: http://www.oracle-base.com/articles/misc/ManualOracleUninstall.php Uninstall all Oracle components using the Oracle Universal Installer (OUI). Run regedit.exe and delete the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE key. This contains registry entires for all Oracle products. Delete any references to Oracle services left behind in the following part of the registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Ora* It should be pretty … Read more
One solution is to install both x86 (32-bit) and x64 Oracle Clients on your machine, then it does not matter on which architecture your application is running. Here an instruction to install x86 and x64 Oracle client on one machine: Assumptions: Oracle Home is called OraClient11g_home1, Client Version is 11gR2 Optionally remove any installed Oracle … Read more
Yes. Once you declare the variables in a PLSQL program, you can use it anywhere in the program. See below an example DECLARE var VARCHAR2 (100); — Variable declared BEGIN var := ‘My name is jack’; — Assigning a string to the varibale DBMS_OUTPUT.put_line (var); — Displaying it. SELECT ‘My name is Mack’ INTO var … Read more
Actual code depends on tool you use. In SQL*Plus, it is the &; in SQL Developer or TOAD, that would be a :. Also, GUI tools usually don’t require enclosing string parameters into single quotes. Here’s a SQL*Plus example: SQL> select * from emp where job = ‘&job’ and sal <= &sal; Enter value for … Read more
This will put each character in a String object into an array of Strings. String[] rp = new String[ket2.length()]; for(int i = 0; i < rp.length(); i++) { rp[j] = “” + ket2.charAt(i); } Tell me if this helps!
I think you want to create a small table of object names and then join, something like: create table objectnames ( name varchar2(100) ); — populate objectnames — could be from a file or another table or whatever insert into objectnames … commit; — query from tables select a.* from abc_table a, objectnames o where … Read more