Write a syntax for update query in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
when loggined as SYSTEM,how to display all the users of database using sql query?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
In the oracle version 9.3.0.5.0, what does each number shows?
Explain the use of inctype option in exp command.
What are the four Oracle system processes that must always be up and running for the database to be useable?
material view and view disadvantages?
What is the difference between substr and instr?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
How oracle handles dead locks?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
What is a trigger oracle?