Combination of oracle 10g database with developer 2000 on Windows XP
sir, i was installed oracle database 10g with developber 2000 on windows xp. but after installing the both combination, i start development using developer 2000. I connect the oracle database table through wizard and then i was successful. but after loading the form & i used a push button and used trigger ‘when button pressed’. [...]

Answer Question   |  August 25, 2010  8:16 AM
Oracle 10g, Oracle Database, Oracle Database 10g, Oracle Developer, Oracle Developer 2000, Oracle on Windows XP, Windows XP

How to connect oracle database 8i (personal edition) with d2000 (forms 4.5 & reports 2.5)?
In the laptop how to connect oracle database 8i (personal edition) with d2k (forms 4.5 & reports 2.5) Pls tell me procedure for this connect with database?    

Answer Question   |  August 25, 2010  6:21 AM
Oracle, Oracle 8i, Oracle 8i error messages, Oracle connection error, Oracle connectivity, Oracle Database, Oracle Forms, Windows XP

Not able to connect to database through Oracle form builder
Iam not able to connect to database through form builder.How to add an entry for your XE database in your tnsnames.ora file?

Answer Question   |  August 17, 2010  11:21 AM
Oracle connectivity, Oracle Database, Oracle Form Builder, Oracle Forms

How to display non existent data as 0 in Oracle
in my table there refno,purchase,sale,acc_type are four columns.i have to sum(b) and sum(c). for a perticular date.but the query should show 0 for clumn b & c where there no value has been entered.suppose purchase,sale, are summing per month.but in some month there is no entry for a,b,c,d.so how to show them for that month [...]

Answer Question   |  August 11, 2010  3:37 AM
Oracle, Oracle Database, Oracle Forms, Oracle Table

Display date in Oracle Toad
how to display all the months between two dates.my fromdate format is ‘mon-yyyy’ and todate format is ‘dd-mon-yyyy’.plz sugest

Answer Question   |  August 9, 2011  3:07 AM
Oracle, Oracle Database, TOAD, Toad Data Modeler

Standby Database Server
I am using oracle 10g and I want to use a standby database for high availability of my database. I did almost everything; but I don’t know how a user can connect to the standby server when the primary has failed. This is my connection string “Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = [...]

Answer Question   |  August 9, 2010  2:00 PM
Database servers, Oracle 10g, Oracle Database, Standby Database, Standby Server

ordering dates in Oracle
how to order the months and year in descending order from a table?suppose there are 2 culomns one contains month and another contains year.then how to show them in an order like jan-2001,feb-2001,mar-2001………like this. plz suggest some answer for this.

Answer Question   |  August 9, 2010  3:49 AM
Oracle, Oracle Database, Oracle Forms, Oracle Table

Need query to retrieve data from a given date in Oracle 10g
i have some data to retrive from one table based upon certain condition.when ever i will query to retrive data [strong]it will return all the data based upon the date range.suppose i will enter 22-jul-2010 then the query should return from the year july-2010 to may be 2011 or 2021.upto the last entry date.if my [...]

Answer Question   |  August 9, 2010  11:33 AM
Oracle, Oracle 10g, Oracle Data Access, Oracle Database, Oracle Query

Connecting databases in Oracle9i
Can u tell me how to connect database files in oracle 9i software

Answer Question   |  August 5, 2010  11:15 AM
Oracle 9i, Oracle Database

Oracle Help?What is the DB dependencies related to object sequencing for DB builds
What is the DB dependencies related to object sequencing for DB builds?

Answer Question   |  August 3, 2010  12:00 PM
Oracle administration, Oracle Database, Oracle development

Database files in Oracle 9i
i had installed in my PC oracle 9i. i dont have time in practice in niit instutute. i had decided i will prctice in my home but problem is i dont used database file in oracle can u tell me setting about db files

Answer Question   |  November 8, 2010  5:40 AM
Database Files, Oracle, Oracle 9i, Oracle Database

Inserting parent and child tables at a time
Is there any way to insert parent and child tables data with select statement? On record in parent table and n number of records in child table. Please let me know if possible.

Answer Question   |  February 22, 2013  6:41 AM
Oracle Database, Oracle Statements, TOAD

How to connect to database inside VMWare from the web applications
Hi All, I have VMWare in my desktop which contains the Oracle database. And in general my desktop is in network with the server having web based applications. Now I want to fetch the data from this VMWare database in my application. Can we establish JDBC connection from the application to this database. Can we [...]

Answer Question   |  July 21, 2010  12:34 PM
DSN connection, Java Database, JDBC, Oracle Database, VMware, Web Dynpro

How to use POS.NET for a BARCODE SCANNER in a VB.NET application
Hi! I have an old office project… Its Point of sale software built in VB.net over oracle db express edition. Its really cool but lucks the barcode scanner functionality. Some customers are demading for that functionality…..bla bla bla!!!  …Devices I’ve programmed 4 in the past usually comes with their .NET API / DLLs  to work [...]

Answer Question   |  January 12, 2011  11:38 AM
Barcode scanners, Oracle Database, VB.NET

Importing sound Class
hi, My technical environment is: Winxp, dev9i AS vers9.0.2, Jinit vers1.3.1.9, OracleDB9i. I created a sound.java file using Oracle9i JDeveloper, I compile it and the result is: ” Compiling… D:Dev9ijdevWorkspaceWorkspace5soundsrcoracleformsfdSound.java Successful compilation: 0 errors, 0 warnings.” I deploy sound.java to sound.jar and the deployed process is completed Successfully. I also executed all the configuration steps [...]

Answer Question   |  June 2, 2010  6:35 AM
Oracle 9i, Oracle Database, Oracle Form Builder, Oracle JDeveloper, Windows XP

Database auditing
Hi everybody? I do have a shema named PRACTICE with its own table named EMPLOYEES. The table has fields: empid,fname,sex and age. Their data types are varchar2,varchar2,varchar2 and number respectively. The fields also held values LA,Lensa,F and 21 respectively. Being on the sys schema, I defined a policy for auditing purpose as follow. begin dbms_fga.add_policy [...]

Answer Question   |  May 25, 2010  12:44 PM
Oracle, Oracle Database, Oracle development, Oracle error messages

Oracle 10g Database Housekeeping
i’ve been asked to work on database housekeeping, i don’t know what i should do? please advice

Answer Question   |  May 18, 2010  8:28 PM
Database housekeeping, Database maintenance, Oracle 10g, Oracle Database

SQL Server 2008 R2 provides direct integration with Oracle Database
Does SQL server 2008 provide direct integration with the databases built-in within an oracle DB?

Answer Question   |  May 7, 2010  8:20 PM
Oracle Database, SQL Server 2008 R2, SQL Server 2008 R2 and Oracle, SQL Server 2008 R2 Features, SQL Server 2008 R2 Integration

No of user for database
How many users can be connected to SQL and ORACLE from application end?

Answer Question   |  November 12, 2011  5:15 AM
Oracle applications, Oracle Database, SQL Server

How does profile limit for PASSWORD_REUSE_MAX works
How does the profile limit for PASSWORD_REUSE_MAX works for Oracle Enterprise Database 9i ? Suppose we set PASSWORD_REUSE_MAX to 5 in a profile for a user. Now this user tries to change his password, then at that point how does Oracle engine checks if the new password the user is giving matches to any he [...]

Answer Question   |  April 15, 2010  3:14 PM
Oracle 9i, Oracle 9i Configuration, Oracle Database, Oracle Enterprise Database 9i