Q by Software engg
can u tell me the syantax by which i can select no of rows in a dummy table in oracle 9i?
Re by YuvalShavit
The standard SQL approach would be “select count (*) from tableName”. Some DBs maintain internal counters that return this result as a simple lookup rather than having to ac[......]
Q by VND
I need to call a Report made in Reports 6i into a Form made in Forms 6i.
Re by Jaweed
WRITE THIS CODE “WHEN BUTTEN PRESS” ON YOUR FORM
DECLARE PARAMID PARAMLIST; BEGIN PARAMID :=CREATE_PARAMETER_LIST(‘TEMP’); ADD_PARAMETER(PARAMID,’PARAMFORM’,TEXT_PARAMETER,’NO’); ADD_PARAMETE[......]
Q by Newbietech
What are the advantages of automated testing tools for oracle database on a Unix Solaris environment?.
Re by MarkK
That depends on what you are comparing to. Automated testing tools have a great advantage over trying to manually test database performance. Please clarify your questi[......]
Q by ITKE
I get the following error on compiling my code – *********************************************************** ORA-06550: line 16, column 1: PLS-00103: Encountered the symbol “ELSE” when expecting one of the following:
begin case declare end exit for goto if loop mod nul[......]
Q by Raza
Hi. I an using oracle 10g. when i run 10g reports individually it works fine but when i try it to connect with forms it gives error ‘cannot connect toserver’ please help how could i connect it to server.
Re by Fhashmat
Where are you trying to run this report, AS or local machine? [......]
Q by OracleATE
How do you create a trigger to take care of the process of updating a table, to reflect a change downward in the quantity column?
1. The trigger needs to be an AFTER INSERT trigger on the above table so the trigger will not fire in case of exceptions.
2. The trigger must fire for each[......]
Q by OracleATE
I am developing an application with VB 6 as front end and Oracle 8i as back end. I need to run my application in other systems also, so I need to export the table structures of my application to other systems. How can I do this? Thank you.
Re by Jcmdba
There are a number of ways to “e[......]
Q by 15091974
I am getting the following error when running the below procedure from TOAD. I have ora 9i OS Windoes XP.
CREATE OR REPLACE PROCEDURE SP_CALL_PROCEDURE22 (BUSINESS_UNIT1 in varchar2) IS CURSOR C1 IS SELECT BUSINESS_UNIT,VOUCHER_ID,INVOICE_ID,VENDOR_ID,GROSS_AMT FROM PS_VOUCH[......]
Q by Oda
I installed RHEL4 on my home pc.and I created 2 databases of oracle 10g (same vesrion)The problem is while iam establishing connectivity between these 2 databases iam getting error like TNS-03505: Failed to resolve name
my listerner.ora file is
LISTENER= (DESCRIPTION_LIST = (DESCRI[......]
Q by 173831
ORA-00600: internal error code, arguments: , , , , , , ,  Current SQL statement for this session: UPDATE "JEST" SET "INACT" = :A0 , "CHGNR" = :A1 WHERE "MANDT" = :A2 AND "OBJNR" = :A3 AND "STAT" = :[......]