Hi everyone, I have a problem in matching regular expression in Oracle PL/SQL. To be more specific, the problem is that regex doesn't want to match any zero occurrence. For example, I have something like: select * from dual where regexp_like('', '[[:alpha:]]*'); and this doesn't work. But if I put space in this statement: select * ...
I have a C# ASMX web service that uses Oracle.DataAccess.Client to connect to an Oracle database. When I try to call a web method I get this error message: unable to load dll 'OraOps10.dll' It's the same problem as asked before, with the significant difference that I do have ODAP (at least I have OraOps10.dll in an Oracle client in...
Hi all I have two questions. (1) how to make move text file from folder: C:\Data\inbox\test.txt to target Folder? C:\Data\outbox\test.txt (2) how to make get list of directory files in Folder? C:\Data\inbox\ Thank you... ...
I connect to an oracle database from an ASP-VBSCRIPT website and want to execute a stored procedure which accepts input parameters as well as returning some. The stored procedure is the following: p_std_currency.get_currency_details(input1,input2,input3,input4,output1,output2) Input 1-4 are the parameters (3rd is dat...
This is a two part question: I would like to know where does Oracle ADF 11g stands as a framework to develop / deploy Web / Java EE Applications as compared to other frameworks. How much is Oracle ADF being used as a framework to Develop Web Applications. I am asking from a perspective that weather there are good job opportunities as ...
Hello! Is adding tablespaces to a database decrease the performance of an Oracle 9 database? We consider that the number of request remains constant. Thx, Eric ...
DROP TABLE table1; DROP TABLE table2; CREATE TABLE table1 ( col1 NUMBER, col2 NUMBER, col3 NUMBER, col4 NUMBER ); CREATE TABLE table2 ( col1 NUMBER, col2 NUMBER, col3 NUMBER, col4 NUMBER ); INSERT INTO TABLE1 VALUES (1,44,1,1); INSERT INTO table1 VALUES (2,44,2,2); INSERT INTO TABLE1 VALUES (3,44,3,...
Hi All, Is there a way you can determine the date when a trigger was updated? The reason why I ask is because a costumer complained about receiving some erros in our application, but when I went to look at the table, it had all triggers disabled. I appreciate any help anyone can provide me! ...
From Oracle: "When you declare a cursor variable as the formal parameter of a subprogram that fetches from the cursor variable, you must specify the IN or IN OUT mode. If the subprogram also opens the cursor variable, you must specify the IN OUT mode." But, I can code that (only OUT parameter): create or replace procedure mycur_out(mc ...
I have an oracle package with a procedure that has a in out reference cursor. My understanding is that this is pretty standard. What I didn't like is the fact that I had to write a ton of code to just see the output. [So I asked this question][1] and it turns out I can get what I want by creating a function that wraps the procedure. ...
I've been looking this over for a while now and can't seem to pinpoint the problem. Does anything stand out that would cause a java.sql.SQLException: No data found ResultSet rs = null; rs = s.executeQuery("SELECT * FROM customer"); out.println("<tr><th>Customer ID</th><th>First Name</th> </th></tr>"); while(rs.next()) { ou...
Hi all I have a Oracle linked server (10.g) on a Sql server 2005. Trying to import oracle table schema(s) into SQL using Select * into ttdsls030010 from openQuery(hades,'select * from baan.ttdsls030010 where rownum =1'); This throws an Error converting data type DBTYPE_DBTIMESTAMP to datetime Is there a way to autocast Oracle type ...
I'm attempting to create a table with an automatic column, the value of which is computed using a function I've defined. However, when I try to create the table I keep getting ora-00907: Missing right parenthesis. Can anyone help? Here is the CREATE code: CREATE TABLE NEW_EMP2 ( SSN CHAR(9), EMP_NUM2 CHAR(5) automatic as newemp2id(SSN...
I am trying to set a savepoint and the rollback to that point when I have a problem. But I get the following message: SQL execution error, ORA-01086: savepoint 'LASTSAVE' never established ORA-06212: at line 1". I have made sure there are no commits until then end but still get the error. I have also wrapped it up in a transaction....
There is the following table: event_table, which contains information about object_name, event_number, event_supplementary_info, event_time. I would like to have a sql query, which shows number of events per last seven day daily and total number. I need something like this select Object_name, event_number max(decode(trim(dow),'MONDAY'...
My dynamic sql below to alter a table & create columns based on the output of a query is giving error. Query : DECLARE CURSOR c1 is select distinct WP_NO from temp; cnum VARCHAR2(255); BEGIN FOR cnum in c1 LOOP EXECUTE IMMEDIATE 'Alter table temp_col add (:1 varchar2(255))' using cnum; END LOOP; COMMIT; END; ...
I used to use mysql, and in mysql database hold tables, but these concepts doesn't apply to oracle, so I don't quite understand the differences. Update: The problem I am facing is, I need to do migration from Mysql to Oracle. I have two switching databases called A and B, in Mysql all the tables are in their corresponding databases. I...
I have a very large table (5mm records). I'm trying to obfuscate the table's VARCHAR2 columns with random alphanumerics for every record on the table. My procedure executes successfully on smaller datasets, but it will eventually be used on a remote db whose settings I can't control, so I'd like to EXECUTE the UPDATE statement in batches...
I'm working on my first Access application and I'm having trouble when I try to insert records from the Access database into an Oracle database. The first record is inserted without error, but the second record raises a "Run-Time Error '3146'" error message. Any ideas? Private Sub Command42_Click() Dim dbMyDatabase As DAO.Databa...
oracle has a good reputation for handling large-scale applications and it's also flexible to extend to cluster environment. Why everyone wants NOSQL? because nosql db is much cheaper? why not swith object-oriented db? ...