Analyze Statistics on Oracle 10g
How do i run analyse statistics on oracle 10g and schedule it for sunday at 04:00 am

Answer Question   |  December 18, 2008  11:31 AM
Oracle 10g Statistical Functions, Oracle ANALYZE command, Oracle automatic statistics collection, Oracle DBA, Oracle Statistical Functions, Oracle statistics

Hide columns and Adjust Canvas in oracle forms
Hi, I need to adjust the canvas and show only the columns selected based on the number of columns selected from the previous screen. screen 1 x – column 1 (checked or selected) – column 2 (unchecked) x – column 3 (checked or selected) screen 2 column 1 – column 3 Any idea what forms [...]

Answer Question   |  January 5, 2010  5:32 PM
Oracle Forms, Oracle Forms Canvas, Oracle Forms Tab Canvas

Use of multiple SET/WHERE clauses in the MERGE of 2 Oracle tables
Currently am able to update 1 Oracle table from another using MERGE along with WHEN MATCHED THEN UPDATE logic. Under the UPDATE command I am using a SET/WHERE to update a specific column based on certain criteria. I want to add another SET/WHERE condition to this same update which will result in an UPDATE of [...]

Answer Question   |  December 23, 2008  3:49 PM
MERGE statement, Oracle Table, PL/SQL, SET/WHERE

ALTER INDEX statement
‘ALTER INDEX ‘ || C_Indices.INDEX_NAME ||’ REBUILD ‘; ‘ALTER INDEX ‘ || C_Indices.INDEX_NAME || ‘ REBUILD ONLINE COMPUTE STATISTICS’; In my stored procedure , i am reconstructing or you can say re-building the tables and table name is the input parameter to the procedure. In middle of the code , i am using execute immediate [...]

Answer Question   |  December 17, 2008  12:54 PM
ALTER INDEX statement, EXECUTE IMMEDIATE statement, Oracle development, Oracle SQL, Oracle stored procedures, SQL statements, Stored Procedures

How to implement Sleep logic not using sleep() need customized
Hi Experts, I need to implement a sleep logic in a loop i need to check for SELECT/INSERT stm if it s locked by other user i will go to sleep mode then back to earlier savepoint position eg savepoint x; INSERT/SELECT i need to check for 10 times each time sleep is for 1 [...]

Answer Question   |  December 18, 2008  12:45 PM
DBMS_LOCK.SLEEP, PL/SQL, PL/SQL block, SLEEP Procedure

Search for a keyword in all columns of all database tables
Dear Team, i have an requirement that : i want to search all the columns of all the tables in the particular database based on the specific key word or an free text. example : table 1: columns data empname sam empid 01 table 2 columns data deptname sam departmentid 10 table 3 columns data [...]

Answer Question   |  December 16, 2008  9:26 AM
Oracle development, Oracle queries, Oracle SQL

How to configure the database instance to respond slowly for any request?
With default configuration settings at DB instance, the db server is responding quick. For my tests, i want the db server response to be slow. What configuration changes or anything else can be done so that the db instance will respond slowly (atleast take 1 minute time to execute). The request can be connect to [...]

Answer Question   |  December 24, 2008  7:24 AM
Database configuration, Database instance, Database testing, DB2, Oracle, SQL Database, SQL Query, SQL Server

PL/SQL: How to handle OUT Parameter during INSERT
HI Experts, I have a OUT parameter in my procedure(whihc performs INSERT data into a table),how to handle this OUT parameter (primary key of table) — Will Insert statement inside the PL/SQL block should include this parameter or we should use SELECT stm after Insert to add this attribute ,i am unclear on this please [...]

Answer Question   |  December 17, 2008  6:56 AM
INSERT statement, OUT parameters, PL/SQL, PL/SQL block, SELECT statement, SQL statements

How do I connect Developer 2000 on one computer to Oracle 9i personal addition on another XP machine
how to connect d2k with 9i from other machine

Answer Question   |  December 18, 2008  10:11 AM
Developer 2000, Oracle 9i, Oracle 9i Personal Edition, Oracle Developer 2000, Oracle Developer Suite, Oracle interoperability, Windows XP

PLS-00103: Encountered the symbol “E_PROD_REQ_ID_NOT_FOUND” when expecting one of the following:
how can i resolve that error? when i compile the store proc….it compiled without any errors….but in a package its throwing error

Answer Question   |  December 13, 2008  8:50 PM
Oracle error messages, PLS-00103, Stored Procedures

System tables in SQL Server 2005
What is the role of system tables in SQL Server 2005 and how do you update them?

Answer Question   |  December 13, 2008  4:20 PM
SQL Server 2005, SQL Server System Tables, SQL Server tables, SYSTEM TABLESPACE

Actuate e.reports vs Hyperion SQR
Hello, in our organization we are evaluating for the best reporting solution tools from Actuate e.reports and Hyperion SQR, So can anybody help me to know the Pros and cons of the tools. In all aspects formatting ability, load, performance [server, client], report bursting, Software complexity and output formats. thanks in Advance,

Answer Question   |  December 12, 2008  2:43 PM
Actuate e.reports, Hyperion SQR

Oracle licensing: I need the documents related with the file F0092
Needs to identify named users in JDE World and One World to ensure compliance with Oracle Licenses. A user may have multiple profiles in multiple environments which in Oracle’s eyes would be counted as one named user We are looking at using the following fields to capture a unique identifier that is associated with a [...]

Answer Question   |  December 12, 2008  10:32 AM
Compliance, F0092, JD EDWARDS, JD Edwards OneWorld, JDE World, OneWorld, Oracle compliance, Oracle licensing, ULUL24, ULUL25

How to insert an image file into an Oracle 8i database?
Hi Experts, I am using forms&reports6i with the oracle 8i database. Now i want to insert a image file into the database and i want to access that in reports. I tried the insert statement but i couldn’t. can anyone help me for inserting.

Answer Question   |  June 15, 2010  9:34 AM
BLOB, Oracle 8i, Oracle 8i image storage, Oracle administration, Oracle Forms, Oracle Forms 6i, Oracle Forms and Reports 6i, Oracle image storage, Oracle Reports, Oracle Reports 6i

PL/SQL: How to use EXCEPTION statement before INSERT?
Hi Experts how to use EXCEPTION statement before INSERT stm in PL/SQL Block Please help me with syntax or format is this option possilbe as well?

Answer Question   |  January 5, 2012  4:20 AM
Database programming, EXCEPTION statement, INSERT statement, PL/SQL, PL/SQL block

PL/SQL: How to check that parameter is case-sensitive?
Hi Experts how can i check the email id shud take only lower case in PL/SQL block i tried using vpos := REGEXP_LIKE(p_email_address,’[:lower:]‘,’C'); as well vpos ;= REGEXP_LIKE(p_email_address,’[^[:lower:]]’,'C’) But both says wrong type as error and p_email_address is a parameter of procedure and i declared vpos as varchar2 please help me!!!!

Answer Question   |  December 18, 2008  4:18 AM
PL/SQL, PL/SQL block, PL/SQL error messages, REGEXP, Regular expressions

How to run a query in PS Query using Microsoft Excel macro
Hi, I am working on a macro in Excel that can automate the running of a query in people soft PS Query application.Result should also be save in Excel format at given path. Here is what i exactly want to do 1. Put all query name under column A.(not entire query only its name) 2. [...]

Answer Question   |  December 11, 2008  9:48 AM
Microsoft Excel, PeopleSoft, PS Query

I need to permanently delete a re-generating job, but I can’t find its source
I have used dbms_job.remove to remove all jobs from dba_jobs, but something is re-submitting a series of jobs every few minutes. I have disabled all triggers and all external cron jobs have been stopped… but more jobs keep getting submitted. I have a single transaction record in v$transaction which is dated July and is very [...]

Answer Question   |  December 11, 2008  11:28 PM
DBMS_JOB.REMOVE, Oracle DBMS_JOB, Oracle development

Finding which columns contain data in a table
I have to establish which columns in a table have data present. Each row has up to 100 columns, and not all of the columns contain data relating to the row. So in Table 1, Col1 Col2 Col3 Col4 Row 1 abc Row 2 abc Row 3 abc Would give a report showing that Table [...]

Answer Question   |  December 10, 2008  3:42 PM
columns, Data migration, Database migration, Oracle Database, Oracle Database to SQL Database Migration, SQL Database

oraoledb non working WHERE clause character comparison
Are there WHERE clause character comparisons that do not work when using oraoledb? I have a SQL query that is well formed and works with both Oracle 9 and Oracle 10g client, but will not execute when parsed via oraoledb.

Answer Question   |  December 11, 2008  1:47 PM
Oracle 10g, Oracle 9i, OraOLEDB, OraOLEDB.Oracle, SUBSTR, WHERE statement