aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • DB2 Administration and Oracle SQL Functions
  • The output of the query " select instr('I am an expert in...
Multiple choice technology databases

The output of the query " select instr('I am an expert in sql functions','n',-10,2) from dual; " is

  1. 30

  2. 7

  3. 2

  4. 10

Reveal answer Fill a bubble to check yourself
B Correct answer

Keep practicing — related questions

  • The output of the query " select instr('I''m an expert in oracle','d',-1,1) from dual; " is
  • select INSTR('TCS_SQL','S',4) from dual;
  • select instr('Hi Partha Sarathi Ojha','a',6,-1) from dual; The output would be..
  • The output of the query " Select length(substr('SQL Functions',-10,12)) from dual; " is
  • select instr('Hi Partha Sarathi Ojha','a',5) from dual; The o/p would be...
  • Select length(-1) from dual What is the output of the above sql stmt
  • Select length(-1) from dual What is the output of the above sql stmt
  • Select length(-1) from dual What is the output of the above sql stmt
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy