Explain what are the type of synonyms?
No Answer is Posted For this Question
Be the First to Post Answer
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.
How to sort output in descending order in oracle?
What is a tns service name?
How to use existing values in update statements using oracle?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
how can we store any pdf file in oracle
Can we create database in oracle using command line ?
Can select statements be used on views in oracle?
How do we represent comments in oracle?
What is rich query?
How to retrieve data from an explicit cursor?
Where are the settings stored for each instance in oracle?