1,488 Topics
 | |
| | I'm trying to connect to Oracle Dbase using VB.net and I don't know how. I'm more familiar with Visual Foxpro 9.0 which is a lot easier. I did not find a way to connect VF to Oracle so I'll try VB.Net . 5 years ago, I am a little familiar … |
| | Hi, I'm trying to load a plain archive (txt) to an Oracle table with SQL Loader, but we are having problems when the field is a Date + time. Only Date gets saved into the field of the table, ignoring the time included. When creating the archive the date + … |
| | hi guys, i'm doin a prjct in which i've used oracle9i @ backend n jsp @frontend.can u tell me how do i retrieve the data back from the database to the jsp.i've successfully inserted d values but i'm clueless as to how to get it back in the proper order.:sad: |
| | I am working on an ASP.net 2.0 application written in C#, pulling data from an Oracle 10g database on a remote server (i.e. the application and database are on different servers). The data is pulled via a SqlDataSource control. When I run small, quick queries, everything works fine, but when … |
| | Hello, This is my first post here, so Hi everyone :). I was advised to come to this site by a friend regarding a query that I have, so here I am. So we have the E-Commerce subject in this semester. One of the case studies given to us involves … |
| | Im a noob in vb.net 2003 and oracle...and I desperately need the expert help regarding a problem that I face.... Im working on a web based system and the system is connected to oracle. In oracle there are 4 tables and Im facing problem with one of the tables. In … |
| | I need to read simple tables from a stream. The tables are created as: CREATE TABLE ny1.allinsured1 ( pol_no numer(120, ... ) / I see the tables are streaming from source db to destination db BUT I cannot seem to access the tables from an OCI streams interface. How can … |
 | Hello DBA, Can any one help me this? The table TEST contains CNAME CNO EXTRA ------------------------------ ---------- ---------- bijaya 645896 mantri 525896 mantri12 525126 testing for null My requirement is to find the column which contains all the rows null(null column) I have created the following procedure to accomplish this … |
| | Does anyone know where to get a skeleton of perl scripts written for Oracle backup and recovery? |
| | I want to put together a set of packages to help in unit testing PL/SQL code - does anyone know of any software ( commercial or not ) or books which I could look at for some inspiration. Thanks Nige |
| | Hello DBAs, Do you have any idea about the XML file used in SP. I want to pass it as input parameter. Thanks, BMantri |
| | I've created a sql statement that I'm try get the number of messages that will expire during a certain time period. I'm looking to purge messages according to mm/dd/yyyy. I'm having a world of difficulty figuring the statement format out assistence would be appriciate. SQL script: select originationtime, expirationtime, ((TO_DATE('01/01/1970', … |
| | hi all, i have a table whose structure is as below: Name Null? Type ----------------------------------------- -------- ---------------- NEWSLETTER_ID NOT NULL NUMBER SUBJECT_VC VARCHAR2(255) MAILTYPE_VC VARCHAR2(50) CONTENT_TXT CLOB SCHEDULE_DT VARCHAR2(50) SYSTEM_HOOK_VC VARCHAR2(50) NSTATUS_SI NUMBER TEMPLATE_ID NUMBER i want to insert data in this table. below is my php script i m … |
| | OK, I'm fairly new to PL/SQL, adn I have a query to write, which is confusing me. Let me explain: I have a table, with three fields, CustID, CustName, Number What I want to do, is identify and display all rows in the table, where the last four digits of …  |
| | has anybody here used the free Oracle 10G database with VB6?? if so, is it easy to setup?? is the connection string similar to an MS Access connection string?? I have heard it is probably the best database. |
| | I have a Date insert that is formatted into an Oracle 9i database and it works. But I had to make the Date variable a varchar2 in Oracle to get it to work: [code=java] java.sql.Timestamp myd = new java.sql.Timestamp(new java.util.Date().getTime()); String sub_date = new SimpleDateFormat("mm/dd/yy , h:mm a").format(myd); String query … |
| | |
| | I am attempting to move from VB 6 to Vb Net using Oracle as the database. I cannot figure out the proper connection and/or access methods needed to retrieve the rows of data from the Oracle tables. I have attached a wordpad text document showing the VB 6 code that …  |
| | create a view as superuser create view V_CUSTOMERS based on Customers Table and give an access to enter, select records to Appuse01,Appuser02,Appuser) and Appuser04 for all the columns excepting Price and Total_val. These two columns will be update by procedure. They should be able to see their records only and … |
| | Greetings, I'm having a heck of a time trying to get this pl/sql program to work. I'm to invoke it using shopper id and then again by shopper last name. I've banged my head on this for a while now and it seems that every change I make creates more … |
| | Hi, I want to store the text data with apostrophe in the table. I tried through this query like this insert into temp values(101,'vijaya's'); but it is giving error - missing comma Could anybody help this sql query for the following requirement? NAME vijaya's rajani's |
| | Help! I'm a beginner. I've just done some short studies in oracle database. I need your help... how to show my data in oracle to appear in interface of visual basic. Your help will improve my knowledge. Thx |
| | Hi, I'm trying to retrieve data (CLOB, string, integer) from a stored function. My example code looks like: $dbh = DBI->connect(....) or die "can't connect"; $stmt = 'BEGIN :cursor := foo; END;'; $sth = $dbh->prepare ($stmt); $sth->bind_param_inout(":cursor", \$refCursor, 0, { ora_type => ORA_RSET } ); $sth->execute(); while ( my ($clob, …  |
| | hai, how to insert picture and movies in oracle9i using jdbc technology. i had some program to implement this process but i can't do this.please help me to implement this program.  |
| | [QUOTE=krnekhelesh;454927]got it... Windows XP[/QUOTE] Hi , Do anyone have any idea regarding the oracle APIs, i am using the APIs os oracle 7.3 client library and i want to make it unicode compatible without changing the APIs, but by just making datatype conversion,is it possible??? |
| | Hi All I am trying to connect to my database from the front end in VB.NET 2003, the connection strings that i have tried are not working at present. I have VB.NET 2003 program from last year but that was using access as the back end and VB.NET 2003 as … |
| | Hi Friends, I am a BSc IT Student. I have to make a project, with VB6.0 as front-end and Oracle 9i as back-end. I would like to know :- a) how to connect the text box, combo box etc... to Oracle database. b) how to insert data from VB form … |
| | Trying to connect to my oracle database from the front end VB.NET 2003 with the connection string but will not do it at present. Is it possible to use my Access connection string in VB.Net 2003 and connect to the oracle database by just changing the connection string for oracle9i.:) |
| | Hellllo everyone I am looking for a tool to volume test my web application...my app has to connect to an Oracle DB so preferably I would like something to simulate enough traffic to max out my connections. Does anybody know of/already have a preference for a web stress tool? Thanks!!! … |
| | Hi, I have just been called for an interview for the role of a trainee Oracle DBA. I have used Oracle, Access and MySQL in the past but only at the university. I know the basics of RDBMS, SQL etc. How do I prepare for the interview in terms of … |
The End.