I am using oracle developer suit(form 10g), On used ole2
objects to initialize excel and worksheet and on "BEFORE
REPORT" i am printing report heading in excel using OLE2
objects only. if i run report from developer suit report
builder it give output in excel normally and what expected
but when ever i put same report on server and run report
from application it gives error : " Terminated with error :
REP-1401 'before report': FATAL pl/sql error occured.
ORA-43356; message 43356 not found; Product=RDBMS; facility
= ORA." Please reply it is urgent
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
3 4620What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?
1582i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee
NIIT,
3 4967Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.
1 10593acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
2 4449
what does it mean to have quoted_identifier on? : Sql dba
Can I work with several databases simultaneously? : sql server management studio
How to show table names with 'mysqlshow'?
What are rdbms concepts?
How to rebuild all indexes on a single table?
Can we connect to ORACLE db using Windows Authentication?
Can I learn sql in a week?
what are the differences between an exclusive lock and a shared lock?
Is microsoft access cloud based?
What stored by the model?
How to get each name only once from an employee table?
What are different joins used in sql?
What is sql performance tuning?
Is primary key an index?
Is mongodb publicly traded?