Interested to Buy Any Domain ? << Click Here >> for more details...
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
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 5674What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?
2023i 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 6085Practice 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 11777acname 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 5517
What are different types of joins in sql?
Why should we use mongodb?
How can you log an error to the server event log from a stored procedure?
How does mongodb connect to atlas?
What is the sql 'in' clause?
How to use "for" statements in oracle?
Explain sql server authentication modes?
Explain the difference between replace() and translate() functions in oracle?
How do you size a resultset?
When was mongodb founded and why it is called mongodb?
What is de-normalization and what are some of the examples of it?
Explain the truncate in oracle?
Mention the key features of couchdb?
1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used?
What is the main difference between union and union all?
