2,627 Topics

Member Avatar for
Member Avatar for mir77

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???.

Member Avatar for debasisdas
0
93
Member Avatar for cutedipti

Hello, plz tell me a perfect book which includes all SQL Queries with solved examples. So i will do well practie with it.

Member Avatar for anubina
0
162
Member Avatar for aman_dba

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 …

Member Avatar for anubina
0
130
Member Avatar for mamtha

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 …

Member Avatar for cgyrob
0
107
Member Avatar for achanga

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,.

Member Avatar for RJCO
0
89
Member Avatar for mcgarry101

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 …

Member Avatar for kvprajapati
0
97
Member Avatar for Jeeva_rtp

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 …

Member Avatar for Jeeva_rtp
0
146
Member Avatar for umair125

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.

Member Avatar for debasisdas
0
54
Member Avatar for rafaelbelliard

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 …

0
31
Member Avatar for bobbygsk

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 …

Member Avatar for crunchie
0
173
Member Avatar for edejonge

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 …

Member Avatar for Ancient Dragon
0
84
Member Avatar for Thirusha

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

Member Avatar for Thirusha
0
100
Member Avatar for Gaurav arora

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

Member Avatar for serkan sendur
0
80
Member Avatar for ppomu

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" …

Member Avatar for ppomu
0
2K
Member Avatar for navarannan

[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 …

Member Avatar for peter_budo
0
143
Member Avatar for plut0564

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 …

Member Avatar for plut0564
0
141
Member Avatar for ppomu

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 …

Member Avatar for peter_budo
0
147
Member Avatar for DUST.ZHU

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 …

0
92
Member Avatar for The king

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 …

Member Avatar for thewebhostingdi
0
122
Member Avatar for skumard

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 …

Member Avatar for cgyrob
-1
694
Member Avatar for Gaurav arora

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 …

Member Avatar for sknake
0
113
Member Avatar for kerek2

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 …

Member Avatar for kvprajapati
0
166
Member Avatar for jamojo

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 …

Member Avatar for jamojo
0
179
Member Avatar for maheen123

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 …

Member Avatar for eloelo22
0
89
Member Avatar for firoz.raj

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]

Member Avatar for cgyrob
0
80
Member Avatar for harsha_kusam

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 …

Member Avatar for harsha_kusam
0
253
Member Avatar for raviseelam

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 …

Member Avatar for hemadri123
0
120
Member Avatar for arunjai

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 …

Member Avatar for arunjai
0
99
Member Avatar for palavi

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 …

Member Avatar for kvprajapati
0
363
Member Avatar for paras14

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.

Member Avatar for kvprajapati
0
41
Member Avatar for harsha_kusam

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 …

0
74
Member Avatar for harsha_kusam

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 …

Member Avatar for harsha_kusam
0
112
Member Avatar for happytjia

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 …

Member Avatar for happytjia
0
212
Member Avatar for Traicey

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 …

Member Avatar for kvprajapati
0
130
Member Avatar for vanpersie

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 // …

Member Avatar for vanpersie
0
250
Member Avatar for haria_kishore

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 …

Member Avatar for anubina
0
88
Member Avatar for deepak_8917

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 …

Member Avatar for anubina
0
214
Member Avatar for juser11

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 …

Member Avatar for kvprajapati
0
798
Member Avatar for rudhra216

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:

Member Avatar for peter_budo
0
88
Member Avatar for 3xxx

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 …

Member Avatar for Ezzaral
0
89
Member Avatar for IanwSA

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 …

Member Avatar for IanwSA
0
123
Member Avatar for ashalalaxmi2002

hi how can access romote Mysql database from local mysql database. like oracle dblinks will also work in mysql.

Member Avatar for bhanu1225
0
267
Member Avatar for khanayub_chand

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.

0
44
Member Avatar for iparkin

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 …

Member Avatar for debasisdas
0
40
Member Avatar for jaseerabubakar

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' : …

Member Avatar for jlm699
0
209
Member Avatar for petrica

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 …

0
109
Member Avatar for plut0564

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

Member Avatar for Ramy Mahrous
0
104
Member Avatar for tombatista

[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 …

Member Avatar for slate
0
155
Member Avatar for robertmacedonia

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 …

Member Avatar for robertmacedonia
0
125
Member Avatar for manish.nankar
Member Avatar for manuhar
0
84

The End.