How to pass parameters to procedures in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What happens in oracle commit?
What is oracle analytical function?
what are pseudocolumns?
What is meant by joins?
Define Transaction ?
How to get a create statement for an existing table?
DBMS vs. RDBMS
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is partitioned table in Oracle?
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.
Where is the export dump file located?