How to test whether the Database tables designed to avoid deadlock occurence?
I heard from our dev team that our db tables are designed such that there is no chance of deadlock. How to test whether the Database tables design avoids deadlock? By reviewing the db scripts (table creation) can we find whether the db table design is deadlock proof or not? What else can we do? [...]

Answer Question   |  December 10, 2008  11:04 AM
Database deadlock, Database design, Database Failover, Database modeling, Database security, DB2, DBFO, Oracle, SQL Database, SQL Query, SQL Server

Asking for IT career and certification advice
I have a bachelors Degree in IT. I have zero experience, I am interested in working in management rather than on a technical track. I would like to work in banks or telecommunication companies rather than pure IT companies. I planed to study Oracle financial Solutions, and some modules in ERP SAP things.my future plan [...]

Answer Question   |  December 8, 2008  10:55 AM
Banking industry, Career development, Certifications, IT careers, IT education, IT jobs, it management, IT managers, MBA, Oracle certifications, Oracle jobs and training, SAP careers, SAP certifications, SAP ERP, SAP jobs, Telecom, Telecommunications industry

Oracle ERP single signon using Active Directory
We are on Oracle 9i and will like to implement a solution to allow Oracle ERP users to signon using Microsoft Active Directory. Thanks Thanks

Answer Question   |  December 3, 2008  9:46 AM
Access control, Active Directory, Authentication, Oracle 9i, Oracle applications, Oracle ERP, Single sign-on, User authentication

Error(7,30): PLS-00103: Encountered the symbol “OUT” when expecting one of the following
I am getting this eror when i compile my procedure with OUT Parameter ,it has got several OUT param ,but only this particular line pops up err msg Error(7,30): PLS-00103: Encountered the symbol “OUT” when expecting one of the following: := . ) , @ % default character The symbol “,” was substituted for “OUT” [...]

Answer Question   |  February 1, 2011  5:16 AM
Oracle development, Oracle SQL, PL/SQL, PL/SQL error messages, PLS-00103

Error(31,19): PLS-00103: Encountered the symbol “INTO” when expecting one of the following
I got this error while compiling a select stm and it s my pckg body however package parameter hav OUT as well IN .. Error(31,19): PLS-00103: Encountered the symbol “INTO” when expecting one of the following: . ( , % from The symbol “from was inserted before “INTO” to continue. Anbody able to help me [...]

Answer Question   |  February 6, 2012  5:12 AM
Oracle development, Oracle SQL, PL/SQL, PL/SQL error messages, PLS-00103

Database offline vs Database stopped vs Database network disconnected?
How Database Offline is different from Database Stopped? How Database Offline is different from DB network disconnection? How Database Stopped is different from DB network disconnection? Appreciate your help.

Answer Question   |  December 4, 2008  4:51 AM
Database administration, Database connectivity, Database management, DB2, Network connectivity, Oracle, SQL Database, SQL Server 2005

SQL Query
Hello everyone, I have the following table: CREATE TABLE MKW ( ID NUMBER, UREN NUMBER, DATUM DATE ); It has the following records: SQL> select * from mkw order by datum,id; ID UREN DATUM ———- ———- ——– 1 3 01-12-08 1 2 01-12-08 2 3 01-12-08 2 2 01-12-08 3 6 05-12-08 4 10 05-12-08 [...]

Answer Question   |  December 2, 2008  4:11 PM
Oracle Database, Oracle developers, SQL Query

How to push the Database into deadlock state?
Hi, We are doing Database FailOver testing (DBFO). As part of this, we want to check if primary db is in deadlock state then what happens? whether the transactions will go to back up db or not? How to get the primary db into deadlock state? Appreciate your help.

Answer Question   |  December 2, 2008  11:44 AM
Database deadlock, Database Failover, Database security, DB2, DBFO, Oracle, SQL Database, SQL Query, SQL Server

Oracle 10g Instance not starting Up
Oracle 10g startup command from SQL Plus gives the following error: ORA-01034 : ORacle not available ORA-27101: shared memory realm does not exist

Answer Question   |  December 1, 2008  2:03 AM
ORA-01034, ORA-27101, Oracle 10g, Oracle 10g error messages, Oracle error messages, Oracle not available, Shared memory realm does not exist, SQLPlus

SQL select
SELECT obj.object_type FROM apps.opt_log_issue log, discov.opt_changed_database_objects obj WHERE –(UPPER(log.resolution(+)) like ‘%’||obj.object_name||’%’ – and trunc(log.resolution_date(+)) – trunc(to_date(substr(obj.last_ddl_time,1,11),’dd-mon-yy’)) <=5 – and trunc(log.resolution_date(+)) – trunc(to_date(substr(obj.last_ddl_time,1,11),’dd-mon-yy’)) >=0) OR (UPPER(log.resolution(+)) like ‘%’||obj.object_name||’%’ and log.resolution_date(+) is null) /

Answer Question   |  December 1, 2008  11:09 PM
Oracle development, Oracle SQL, SELECT statement, SQL Query, SQL statements, WHERE statement

can we install oracle10g client version and oracle 10g server on the same machine? will it work fine?
can we install oracle10g client version and oracle 10g server on the same machine? will it work fine? If there will any problem so what will the problem? Please any one explain me. Thanks in advance. It’s urgent please

Answer Question   |  December 1, 2008  7:02 AM
Oracle 10g, Oracle 10g Client Version, Oracle 10g Server

Number precision
What is the default precision of a variable declared as a datatype “NUMBER” in pl/sql

Answer Question   |  December 1, 2008  10:00 PM
PL/SQL, PL/SQL Default Precision, PL/SQL Variables

use 32gb ram with oracle 10g and windows 32bits
how can i use 32GB ram with windows 32bits and oracle 10g?

Answer Question   |  December 1, 2008  7:49 PM
Oracle 10g, Win32

How to synch Lotus notes grop/contacts to my java application group/contacts ?
Hi, I am new to lotus notes and wanted to synch lotus notes group/contacts to our application which is java. The requirement is we need a facility to copy/synch the lotus notes group details (including the group member contacts to the application ), that is a one way (from lotus notes to application groups details [...]

Answer Question   |  December 1, 2008  7:38 PM
Java, Lotus Notes Contacts, Lotus Notes Groups, Lotus Notes Synchronization, Oracle Database

oracle reports mailing labels
I thought I had set the mailing label type in oracle reports in previous versions(6i) I can’t find the option to do that now in version 9.0.4 (10g release 1). Does it exist

Answer Question   |  November 26, 2008  4:28 PM
Oracle Reports, Oracle Reports 10g, Oracle Reports 6i, Oracle Reports Mailing Labels

OS/400 V5R3MO to Oracle 10g
I like to migrate a database which is in IBM OS/400 V5R3MO (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures which I like to migrate from source to oracle too. As I know Oracle migration workbench works on V4R5 0R V4R3 but not on V5R3MO .So there any other [...]

Answer Question   |  June 9, 2010  2:44 PM
iSeries, Migration from OS/400 to Oracle 10g, Oracle 10g, Oracle Migration Workbench, OS/400, OS/400 and iSeries, V5R3MO

How to call Microsoft Excel from Oracle Reports/Forms 6i
how to call excel from oracle report/forms 6i plz tell me the step by step process how can we do it my e-mailid is lightmobeen@yahoo.com if any one know the process plz send me mail sonsist of code,me very thankful to u for this

Answer Question   |  November 21, 2010  10:55 AM
Excel import/export, Microsoft Excel, Microsoft Excel import/export, Oracle 6i, Oracle 6i import/export, Oracle developers, Oracle Forms, Oracle Forms 6i, Oracle import/export, Oracle Reports

“a program is trying to automatically send e-mail on your behalf” in D2k form
whenever i send mail automatically throug D2K forms&Report I get a Message ‘a program is trying to automatically send e-mail on your behalf’. i t will ask for a confirmation yes or no’ it goes every time to the user. now if user will click on no then this mail will not go. so i [...]

Answer Question   |  November 26, 2008  4:41 AM
D2K, D2K Forms, D2K Mail, D2K Report, PL/SQL

Migration
I like to migrate a database which is in IBM OS/400 V5R3MO (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration workbench will able to do so or is [...]

Answer Question   |  November 26, 2008  10:58 PM
iSeries, Migration from OS/400 to Oracle 10g, Oracle 10g, Oracle Migration Workbench, OS/400, OS/400 and iSeries, V5R3, V5R3MO

DB2/400 to Oracle 10g
I like to migrate a database which is in IBM DB2 /400 V5R3MO supported by windows platform (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration workbench will able [...]

Answer Question   |  November 21, 2008  8:03 PM
AS/400 migration, DB2/400, iSeries Navigator, Migration from DB2/400 to Oracle 10g, Oracle 10g, Oracle migration, Oracle Migration Workbench, V5R3