to write code
i have created a table “stu” in which the following record exists. stu_id,stu_name,stu_course,stu_marks the stu_marks column output is as follows 822 758 789 658 822 879 598 825 589 785 795 795 658 789 988 what i want is to write query or code (function,procedure or anything) that when i execute it prompts the user [...]

Answer Question   |  September 22, 2008  11:06 AM
Oracle SQL, SQL

AIM
What is the literal for AIM?

Answer Question   |  August 19, 2008  11:06 PM
Applications Implementation Methodology, Oracle AIM, Oracle Literals

Report taking long time before opening
Hi All We are running Oracla based ERP solution. 9i , D2K and JVM. Everyday after 6 PM all the reports are taking long time before opening I am using HP Proliant DL 380 G5 server with 2 GB RAM having 2 partitions . C mirrored 2 x 72 GB SAS HDD. D drive with [...]

Answer Question   |  August 14, 2008  3:25 PM
D2K, ERP, JVM, Oracle 9i, Oracle Developer 2000, Oracle performance

Changing characterset in an existing Oracle Instance
We currently have an instance in use that has the characterset of US7ASCII. The vendor of the application running on that instance has suggested we change to WE8MSWIN1252. do you think that any data could get corrupted when going from a 7-bit characterset to the 8-bit one and can we do this in place by [...]

Answer Question   |  August 22, 2008  3:12 PM
Character Set change, Oracle, Oracle instance, US7ASCII, WE8MSWIN1252

upgrade from Oracle 9i to 10g
I am trying to upgrade a copy 9i Production database to 10g. Using DBUA tool. After selecting the DB for the past 20 hrs the process is still running with no progress. Alert log has the message on MMNL. What are the possible ways to upgrade a 9i DB to 10g. Have followed the oracle [...]

Answer Question   |  November 5, 2008  2:07 PM
Oracle 10g, Oracle 9i, Oracle upgrades

Join clause vs. nonequi join
pls help, can using clause is simmilar to non equi join,if yes how is it

Answer Question   |  August 15, 2008  1:49 PM
Join logical files, JOIN statement, Oracle developers

Nonequi join and self join as inner join
pls Help, can we call non-equi join and self join as inner join ,if yes pls give some resion

Answer Question   |  August 13, 2008  1:47 PM
Join logical files, JOIN statement, Oracle developers

Inserting without duplicating
I need to create a row and to ensure that the row I’m creating does not already exist. I’m doing this in a pl/sql program.

Answer Question   |  August 13, 2008  5:19 PM
PL/SQL

RMAN Script
can anybody provide me script for RMAN backup on HP-UX with option backup on DISK and backup on TAPE too? If possible also tell how to take copy of disk backup on tape by using ‘BACKUP BACKUPSET’.

Answer Question   |  August 12, 2008  8:02 AM
Backup, BACKUP BACKUPSET, Backup to Disk, Backup to Tape, HP-UX, Recovery Manager, RMAN

job problem
i create a job for updating table and make auto drop after that , the problem that when i create this job, one time it’s created and one time not , in regular way , and this is the procedure. begin dbms_scheduler.create_job( job_name => ‘DropIp_test’, job_type => ‘plsql_block’, job_action => ‘begin dbms_output.put_line(”DELETE EXPIRE : this [...]

Answer Question   |  August 11, 2008  11:21 AM
DBMS_SCHEDULER, PL/SQL

Link Oracle 10g with Sql server problem
i have created a link between our Oracle DB and SQL server db it was succussfulty created and i was able to select data from oracle table using SQLServer. then i have created a view in sqlserver using this link to read from Oracle, the view was created create view dah_test as ( SELECT count(*) [...]

Answer Question   |  August 24, 2008  8:00 AM
Error 7399, Oracle 10g, Oracle error messages, OraOLEDB.Oracle, SQL Server errors

Error:1327 during installing orcale 10g
I downloaded 10g express edition and tried to install to windows xp. An error 1327:Invalid Driver:E prompted. There is no E drive at all. Not sure what is going on? Anyone could help?

Answer Question   |  August 19, 2008  6:29 PM
Error 1327, Oracle 10g, Oracle installation

Oracle D2K report printing extra space at ery page problem
Hi, when I m trying to take print out of oracle reports, print is coming fine but it leaves space at starting of evry page,like that space gets increses at evry page. OS is winXP..do i need to config in .PRT .. im using printer winproLQ1050+. plz help me out. Shailesh

Answer Question   |  September 11, 2008  10:03 AM
.prt files, Developer 2000, Epson LQ1050+, Oracle 8i, Oracle Reports

Calling an Oracle stored procedure from SQL Server
Is it possible to call an Oracle stored procedure from SQL Server?

Answer Question   |  May 10, 2010  3:59 PM
Oracle, SQL Server, Stored Procedures

error in reunnig sql plus
when runnig sql plus of oracle 9i,after giving puser id and password protocol adapter error is there..iused both id an pw i.e. system and manager or scott/tiger

Answer Question   |  August 8, 2008  12:20 PM
Oracle 9i, SQL, SQL error messages

what is the diff between cursor and plsql table
what is the diff between cursor and plsql table

Answer Question   |  August 7, 2008  3:34 AM
Cursor Table, PL/SQL Table

Oracle Database’ Optimization Criteria
Hi ALL, I want to know – - What are the Criteria upon which one can say that Oracle Database is Designed, Set Up and is Running Optimally ? - Beside BRTOOLS ( in SAP on Oracle Db), is there any other Tool through which we can Validate the Oracle Database Structure ? ( Any [...]

Answer Question   |  August 7, 2008  9:05 PM
Oracle database design, Oracle performance

Error accessing Oracle data using SQL job
I have a DTS package that use the MS OLE DB provider for Oracle. The DTS package executes stand alone; but when placed in a schedule job, it won’t run. This was working; but quit after I had detached some databases to copy them. After re-attaching them, the jobs would no longer run. I have [...]

Answer Question   |  September 9, 2008  4:11 PM
DTS Package Scheduled Task, OLE DB, Oracle 7, SQL Server 2000

DNS Server change effect on oracle connections
Hello, There is going to be a change in DNS server at our site. Also, there is going to be migration from Static to DHCP IP, but it has been assured to us that IP address will not change. All our databases are accessed via DNS alias entries in TNSNAMES.ora. Will a change in DNS [...]

Answer Question   |  August 8, 2008  11:39 AM
DHCP, DNS, Oracle performance

inserting
from front end we will get 20 records at a time.how can we insert them into a table .

Answer Question   |  August 21, 2008  6:38 AM
INSERT statement, Oracle