Oracle - What does it do???
Ok, Needing a little help, I need to know what oracle is/does/how ir fits in to every/other things and why? if anyone could give me a brief description that would be great. Thanks.
Ok, Needing a little help, I need to know what oracle is/does/how ir fits in to every/other things and why? if anyone could give me a brief description that would be great. Thanks.
0 pts.
Oracle 9i Server and XP Pro
I have installed Oracle Server 9i on a Windows XP machine. It works well when connected to from the same machine. It is not possible to connect to from another machine (Win 2000)using Client 7i or Client 9i or Client 9i, as though the listener wouldn't work. Is there any known issue with 9i...
I have installed Oracle Server 9i on a Windows XP machine. It works well when connected to from the same machine. It is not possible to connect to from another machine (Win 2000)using Client 7i or Client 9i or Client 9i, as though the listener wouldn't work. Is there any known issue with 9i...
Mainframe to SAP
Hi, I'm a cobol programmer working on Mainframes with a work exp. of 2 yrs. I've worked in technologies like JCL, COBOL, VSAM, DB2, IMS DB/DC, IDMS, FOCUS etc. I have an opportunity to get into SAP technical(ABAP/4) as a programmer in my organisation. Looking at the future prospects of the...
Hi, I'm a cobol programmer working on Mainframes with a work exp. of 2 yrs. I've worked in technologies like JCL, COBOL, VSAM, DB2, IMS DB/DC, IDMS, FOCUS etc. I have an opportunity to get into SAP technical(ABAP/4) as a programmer in my organisation. Looking at the future prospects of the...
Doubts regarding speed in data access
y name is Yahya. I am working as a Project Leader in an IT Industry in India I am working on a new project with J2EE technology. I am using Weblogic Application Server and Iplanet Web server for this project. It is for a bank. I will have to write a program in the server which will read a...
y name is Yahya. I am working as a Project Leader in an IT Industry in India I am working on a new project with J2EE technology. I am using Weblogic Application Server and Iplanet Web server for this project. It is for a bank. I will have to write a program in the server which will read a...
Oracle Client 7.3.4 installation on Windows server 2003
hi, I need to install oracle client 7.3.4 on windows 2003 server.When I tried ,seemed like there is product available latest for only windows NT. Is there any work around for this ? ------------ If there is no way we can install ora client 7.3.4 on windows 2003. How do I handle the OCI calls...
hi, I need to install oracle client 7.3.4 on windows 2003 server.When I tried ,seemed like there is product available latest for only windows NT. Is there any work around for this ? ------------ If there is no way we can install ora client 7.3.4 on windows 2003. How do I handle the OCI calls...
Zebra printer will not print CORRECTLY through Oracle application(s)
Glad to see that some of you all have experience with Zebra printers!!! My problem is that I cannot get my custom Oracle application to print correctly to a Zebra TLP 2742 printer. The problem started when an (older) hand held "pistol" scanner failed. Connected to a laboratory balance via...
Glad to see that some of you all have experience with Zebra printers!!! My problem is that I cannot get my custom Oracle application to print correctly to a Zebra TLP 2742 printer. The problem started when an (older) hand held "pistol" scanner failed. Connected to a laboratory balance via...
Installing Oracle 8i and 10g on Same machine
I want to Install Oracle 8i and Oracle 10g on Same machine. Which version of Oracle to install first? Is there any precedence of installing different versions of Oracle on same machine? If the precedence change, will it cause any problem? Kindly Suggest. Thanks in advance, Karthik
I want to Install Oracle 8i and Oracle 10g on Same machine. Which version of Oracle to install first? Is there any precedence of installing different versions of Oracle on same machine? If the precedence change, will it cause any problem? Kindly Suggest. Thanks in advance, Karthik
Oracle Sql Tuning
Hi everybody. I need some help with Sql Tuning. I have a query that returns information from many tables (let's say 5 for the example). 2 of that tables are big tables (20 million rows each one). I usually write 'where' clauses putting first the join conditions and after them, the table specific...
Hi everybody. I need some help with Sql Tuning. I have a query that returns information from many tables (let's say 5 for the example). 2 of that tables are big tables (20 million rows each one). I usually write 'where' clauses putting first the join conditions and after them, the table specific...
16 bit application connection to ORACLE 9
Our company has previously developed 2 old software 16-bit applications that connect to ORACLE v7. Q: Is it possible to get these apps to connect to ORACLE 9? I'm told that this may be generally regarded as a 16 Bit to 32 bit issue, and that we may need some an interface/translation from 16 Bit...
Our company has previously developed 2 old software 16-bit applications that connect to ORACLE v7. Q: Is it possible to get these apps to connect to ORACLE 9? I'm told that this may be generally regarded as a 16 Bit to 32 bit issue, and that we may need some an interface/translation from 16 Bit...
DataBase Administration
Hello everybody. We have an Oracle 8i DataBase of aprox. 30 GigaBytes. There are 3 big tables using about 50 % of that space, and our DBA is planning to move these tables to another database, to make the administration and backup procedure easier... but I'm not sure about that. Is that a good idea...
Hello everybody. We have an Oracle 8i DataBase of aprox. 30 GigaBytes. There are 3 big tables using about 50 % of that space, and our DBA is planning to move these tables to another database, to make the administration and backup procedure easier... but I'm not sure about that. Is that a good idea...
Oracle Longops Queries.
Hi, Does anyone know the criteria based on which oracle defines a query/transaction to become a candidate for longoops.
Hi, Does anyone know the criteria based on which oracle defines a query/transaction to become a candidate for longoops.
ORA-01000 error even if all statements and resultsets are closed in finally
I am getting ORA-01000 error even if I have closed all statements and resultsets in finally for all query (not using prepared statements). Also OPEN_CURSOR is set to 500. We are using Oracle 8.1.7 and in JDBC driver 'Enable Resultset' is ON and 'Enable Closing cursors' is OFF Please suggest how to...
I am getting ORA-01000 error even if I have closed all statements and resultsets in finally for all query (not using prepared statements). Also OPEN_CURSOR is set to 500. We are using Oracle 8.1.7 and in JDBC driver 'Enable Resultset' is ON and 'Enable Closing cursors' is OFF Please suggest how to...
Print Numbers in words
By using a single SQL Query Is it possible to print numbers in words. Example : To print "5,550 Dollars" in words Expected Query result : "Five Thousand Five Hundred and Fifty Dollars Only" Is it Posssible by a single query
By using a single SQL Query Is it possible to print numbers in words. Example : To print "5,550 Dollars" in words Expected Query result : "Five Thousand Five Hundred and Fifty Dollars Only" Is it Posssible by a single query
Reading, Deleting, Writing Rows to Oracle Data Base
We have a 3rd party warehouse package that utilizes Oracle. In order for us communicate with our I5 to this package, we need to read/delete rows from an Oracle database file on a PC running Windows 2003, and also write records to another Oracle database file running on the same PC. Any pointers...
We have a 3rd party warehouse package that utilizes Oracle. In order for us communicate with our I5 to this package, we need to read/delete rows from an Oracle database file on a PC running Windows 2003, and also write records to another Oracle database file running on the same PC. Any pointers...
Regarding Oracle connectivity issues
I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the...
I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the...
Date conversion (to_char) behavior
Hi everybody. We are experiencing a strange behavior with a "to_char" conversion: We are using Oracle 8i and Developer 6i. An application need to know the day of the week (number of day) of a given date, and we are doing that with "to_char(given_date,'D')". This returns a 1 for sunday, and 7 for...
Hi everybody. We are experiencing a strange behavior with a "to_char" conversion: We are using Oracle 8i and Developer 6i. An application need to know the day of the week (number of day) of a given date, and we are doing that with "to_char(given_date,'D')". This returns a 1 for sunday, and 7 for...
SQL Server 2005 adoption
My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult...
My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult...
Seeking white papers on .NET connector and JCo
Where can I find white papers with information on .NET connectors and Java connectors for SAP? I have searched many Websites but I can't find the right information. Thanks for sharing your ideas.
Where can I find white papers with information on .NET connectors and Java connectors for SAP? I have searched many Websites but I can't find the right information. Thanks for sharing your ideas.
Understanding SAP security risks
What is a good resource to help me understand the risks of assigning the &NC& authorization group to a table? I am worried about these tables being accessed by "unauthorized" users? Please post your thoughts. Thank you!
What is a good resource to help me understand the risks of assigning the &NC& authorization group to a table? I am worried about these tables being accessed by "unauthorized" users? Please post your thoughts. Thank you!
SQL Query Perfomance Issue.
Hi All, This is Wasim Ahmed. I basically wanted a kick start to tune my SQL Queries for performance. I have a huge query which is taking an average of 30seconds for records in thousands. I want to improve the efficiency of the Query. Can any one help me in this. I am pasting my SQL query. I...
Hi All, This is Wasim Ahmed. I basically wanted a kick start to tune my SQL Queries for performance. I have a huge query which is taking an average of 30seconds for records in thousands. I want to improve the efficiency of the Query. Can any one help me in this. I am pasting my SQL query. I...
