2,627 Topics
![]() | |
Dear Programmers, How can I dispaly and insert other language (Arabic/hindi/bangla/chinees etc) through form level field at run time window directly by keyboard???. | |
Hi Friends I am working as an asst. DBA in a Software Company. I am using SQL SERVER and Oracle 9i both to create and maintain database. I am also pursuing my administration in Oracle. I usually analyze that most of the companies with high profile are using Oracle and … | |
I have to create a report based on the customer for particular order. For example find all the customers who ordered an item ‘ABC’ for current month and look back 11 months to find out if the same customers ordered the same item and list all the customers who ordered … | |
can some one help me, i have used redhat enterprise server 4.0 for 3 months now i want to set up an oracle server what do i need to install such that he server can be accessed by every one in my network? Thank you,. | |
Hi, I am wondering if anyone here has ever attempted to connect to the oracle 10g xe database from visual web developer? I have been trying to do this all day, however it is starting to get really irratating! I have downloaded the oracle dataacess dll, and imported it into … | |
Hi There. I am newbie. I need some helps on the below issues. Please help me! 1. How to create / delete user in Sql / Oracle? 2. How can I set privilages while create a new user? 3. How can I view all forms / tables? 4. How can … | |
i need a source code of LIBRARY SYSTEM or a RENT A CAR System plz help me. the code should be written in oracle. thank you. | |
Hello there. My name's Rafael Belliard, and I'm a young software developer for an Oracle-based IT consulting firm, working on the web development departament (ASP.NET). My hobbies include programming, going to the movies (by myself), hanging out with my friends and reading whatever I can find on the web 'til … | |
Hi, My system became slow and I doubt that some unwanted software is being installed to trace my activity. The following is the log file of HijackThis of my sys. Please advise. Your help is appreciated. Logfile of HijackThis v1.99.1 Scan saved at 9:44:02 AM, on 6/26/2009 Platform: Windows XP … | |
Greetings All, After recently being laid-off I'm looking into some government funded training. They will pay for me to take a course with any local college so long as I have a diploma or cert within two years. One that stood out to me takes 10 month and leaves me … | |
I m trying to execute the sdo_migrate.to_current method like this : [CODE]execute sdo_migrate.to_current('tablename');[/CODE] but i keep getting invalid sql error, and i dont understand why. Please help | |
Hi all i m working on a component to generate reports. when user uses this component it should prompt the user wheather oracle/SQL server/Access should be used. on the basis of the user's input it must display the database connection wizard | |
Hello, I need the jsp scripts to retrieve data of my radio button from database to my form which i have developed using jsp and connected to oracle database. Find below sample of my radio button code. Thank you [code=html]<td width="147" valign="middle"><input type="radio" name="biztype" id="biztype3" value="corporate" onclick="checko();"/> Corporate/Limited</td> <td width="182" … | |
[B][B][COLOR="Red"]Hi I need to develop an application which reads a csv file from a server does data validation and write to a file and then bulk upload the data to an Oracle database. The details of the requirement is The input csv file contains data that has to be populated … | |
Hi, Has anybody got a shell script to see what is filling a mount point? It's my oracle mount point but I can't see anything writing to it when I check using ps -ef | grep *log nothing stands out are there any other commands I can use, it's solaris … | |
Hello, I have developed a web based application using jsp and connection as Oracle 9i database. The problem encountered is that whenever I am opening any jsp pages, a session is being created in the database which even after being killed did not disappear. In fact it should be that … | |
I create an application with three threads(access oracle database by bde tquery) main program:random select,insert data;cycle:10S thread1:random select,insert,delete data;cycle:10s thread2:random select;cycle:60s thread3:random insert;cycle:20s five errors occur between 24 hours,longest interval:12hours;shortest interval:0.5hour, error as following: "Lost communication with SQL server.ORA-03113:..." "General SQL error. ORA-03114:..." ping database is ok during error; the … | |
hi every one , i have a problem in asp.net server when i run the site it give me this error in internet browser plz if any one can help me and thanx for all of u, and this problem in oracle server (ISQL plus)also the error msg: ((Internet Explorer … | |
Hello, I am new to Crystal Reports with Oracle. I am trying to create a report ( in Crystal Reports) from an existing Oracle Database. The problem I am having is that I can get the tables but when I do a "browse Data" within the table, there are these … | |
hi all, i m working on a component for MIS department. i need that when i run my component it should ask for: from where u want to retrieve ur data i.e. from Oracle/SQL Server/MS-Access. when i select one of these options for ex. if i select Oracle or SQL … | |
Hi Alls, I'm really need your's help... I develop console application as a engine to pull data from oracle to SQL...the connection to both database is ok..but when to insert got problem....somebody help me plz.... [CODE] 'Connection To Sql Dim sqlcn As SqlConnection Dim sqldr As SqlDataReader Dim sqlda As … | |
Hello Everyone, I am using ths class as my reusable SQL select for my queries in other classes. But when I used this in other classes, it generated me this error: java.sql.SQLException: Network error IOException: Address already in use: connect Can anyone give me some idea or advise on how … | |
Hi I want to update a database record using vb forms. Im using a button for this purpose...how can i do this.. is there any way like in oracle that just a commit statement save changes.. here i need to write all fields and assign their values in db... please … | |
Can anyone tell me .what will return this subquery.any help would be Greatly appreciated.kindly help me.it will return single row or multiple row if single then how.kindly let me know some idea. [code=oracle] select * from sub where job=(select job from job) [/code] | |
Hi All, In my python script i use to run some oracle queries for this i require a library to connect to oracle which is [B]cx_Oracle[/B]. When we were using 9i(oracle).. my script was running fine.. and now when we migrated to 10 G its giving problem... Few lines of … | |
Hi All, I created a table with blob datatype in oracle and store the .doc and pdf file in that column But when i try to access the data from that table i am faceing an error data is corrupted. i am using php 5.2 and adodb driver and oracle … | |
Respected users, i am working on a small project in VB6 following are some requirements, i am attaching the screen shot also ... 1. it gets the sql files in a list once click it opens in rich text box. 2. when the query is run it should populate the … | |
Hi all, I have a core java application, I am getting the below exception when ever i run this application. I have a java file named Oracpt.java which takes all variables like username password and url from setttings file which from config file. becoase of this below exception im not … | |
hello sir i am having the problem in auto number in asp.net 3.5 with oracle 9i as back end .how to increment the no.in the asp.net 3.5 please suggest some solution its urgent. | |
Hi All, We have beenn migrated from 9i to 10g and one of our python script is still pointing out to 9i libraries [B]import cx_Oracle[/B] when it's trying to import this library my script is failing ImportError: ld.so.1: python: fatal: libclntsh.so.9.0: open failed: No such file or directory Could some … | |
Hi All, We have beenn migrated from 9i to 10g and one of our python script is still pointing out to 9i libraries [B]import cx_Oracle[/B] when it's trying to import this library my script is failing [B]ImportError: ld.so.1: python: fatal: libclntsh.so.9.0: open failed: No such file or directory[/B] Could some … | |
First of all. Sorry if I don't have a good English... My operating system is Windows XP SP2 I'd created script files below for creating Oracle database manually: dbcamin.bat [code]mkdir C:\oracle\product\10.2.0\admin\dbcamin\adump mkdir C:\oracle\product\10.2.0\admin\dbcamin\bdump mkdir C:\oracle\product\10.2.0\admin\dbcamin\cdump mkdir C:\oracle\product\10.2.0\admin\dbcamin\udump mkdir C:\oracle\product\10.2.0\admin\dbcamin\dpdump mkdir C:\oracle\product\10.2.0\flash_recovery_area\dbcam in mkdir C:\oracle\product\10.2.0\admin\dbcamin\pfile mkdir C:\oracle\product\10.2.0\cfgtoollogs\emca\dbcamin mkdir C:\oracle\product\10.2.0\flash_recovery_area mkdir C:\oracle\product\10.2.0\oradata\dbcamin … | |
Hi all I am trying to retrieve a data from Oracle database and display it in the textboxes to be editable but with no luck, am getting a ORA error, [COLOR="Green"]missing right parenthesis[/COLOR], that sounds easy and I also thought, I put in the right parenthisis but still it is … | |
Hi guys Iwant to connect java to oracle ,but Iam not familiarneither jdbc nor in setting classpath however depending on my little information,I used the following code [CODE=java] import java.sql.*; public class OraThin { public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("oracle.jdbc.driver.OracleDriver"); // // or // DriverManager.registerDriver // … | |
hi I have 3 tables - table1,table2,table3 table1 has 3 columns named col1,col2 and col3 and has 1 dummy record with values 0,1,2 respectively. The other records are my master records col1 col2 col3 0 1 2 A B C AA BB C D E F table 2 has the … | |
i have a database containing 100 questions . i want to select random 10 from it. how to do that? there is another database containing 100 questions. questions are stored along with an attribute level. there are 10 levels. so there are 10 records whose level value is 1 and … | |
Am having problem calling a simple stored proc to insert data from a java program. The insert statement works fine when called directly with prepare statement. But when I use call it through a strored proc I get an error. jar file is ojdbc5.jar. - oracle10g. Then i tried another … | |
hi, any one plz tell me how to connect oracle database with the help of struts . i am begginner in struts or plz send me some tutorial in struts or plz send me some sample project in struts thank u:eek: | |
I am more interested to know a site that got sample web access code -- to access SQL server / oracle database == could include any of the following language --- c# , vb.net, jsp --- asp, javascript -- ajax answer could be in form of the coolest CMS on … | |
I have a Dell Laptop running Windows XP and a pretty standard Dell 101 keyboard plugged straight into a USB port. I'm running MS Office version 2007. Sometimes when I start an application (any of the office programmes, including outlook, Windows explorer, Oracle) and sometimes when I've been typing for … | |
hi how can access romote Mysql database from local mysql database. like oracle dblinks will also work in mysql. | |
I am using vb6 and Oracle as Frontend and backend.Data Report is being used for reporting,but the problem is even after closing the report, the Session for that report still exists. I needed a way wherein, I can dispose the Session when the report's unload event is fired. | |
I am not a new member, but I want to introduce myself anyway. I am a programmer analyst working with a major Oracle Forms/ Oracle Application. From time to time I do some Pro C programming and PL/SQL, but the majority of my work centers around production of reports using … | |
I am trying to write a scipt which will take a movie name, search it in google with 'I am Feeling lucky' and return the redirected page. [CODE]import urllib.request import urllib.response import urllib.parse proxy=urllib.request.ProxyHandler({"http":"http://www-proxy.us.oracle.com:80"}) auth=urllib.request.HTTPBasicAuthHandler() opener=urllib.request.build_opener(proxy,auth,urllib.request.HTTPHandler) urllib.request.install_opener(opener) url= 'http://www.google.co.in/search' values = {'hl' : 'en', 'q' : 'Departed imdb', 'btnI' : … | |
Hello, I'm working on a project using web services in C#. I have a Oracle database and different clients are requesting data using the web services from the Oracle database. In time after a few hours of running the web services IIS server memory usage seems to increase. I've checked … | |
Has anybody used this microsoft tool SSMA? I can connect the two databases OK, and can convert tables from ORACLE to SQLSERVER 2005, but the data refuses to go across. Any info will be helpful. Thanks, Jim | |
[CODE]Test = ''' SELECT /*+ INDEX (s_evt_act acc_temp_teste) */ todo_cd tipoemail, name subject, email_sndr_addr remetente, evt_stat_cd status, to_char(trunc(created), 'yyyy-mm-dd') data, COUNT(1) quantidade FROM sblprod.s_evt_act WHERE created >= TO_DATE(:DATAI, 'yyyy-mm-dd hh24:mi:ss') AND created <= TO_DATE(:DATAF, 'yyyy-mm-dd hh24:mi:ss') AND todo_cd IN ('Email - Entrada','Redução de Preço','Fax - Entrada','Email - Saída') GROUP BY … | |
Hi, I created a simple application in Oracle APEX, and on the first page (blank page), I put a textbox. Now, I want to be able to insert the input data from the textbox into the tables, e.g. insert new first name, last name etc... Can someone tell me if … | |
Can anyone suggest me how to create web pages using PlSql?? ![]() |
The End.