What is oracle thin client?
No Answer is Posted For this Question
Be the First to Post Answer
What is Oracle table?
How many file formats are supported to export data?
What is a data lock in oracle?
Why do you use stored procedures and state some of its disadvantages?
Difference between pre-select and pre-query
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is bind variable in oracle 11g?
What are the predefined tablespaces in a database?
what are steps for interface? where is exchange rate defined in which table?
Can we store pictures in the database and if so, how it can be done?
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.
Is there a combination of "like" and "in" in sql?