1. If month inbetween jan and jul then 2022 else 2023. What function used to find and how? 2. Analytical functions example 3. Challenges faced in previous project
Desarrollador Oracle Pl Sql Interview Questions
1,525 desarrollador oracle pl sql interview questions shared by candidates
Mostly they covered all SQL concepts
Q: What is views and Materialized views.
Technical and coding. Basics of technology.
Different types of SQL join
delete row 3 with primary key ... add row 3 again but it should come exactly at the place of previously deleted 3
They have asked technical questions.
Difference between rank and dense rank
what is normalizaion how many noraml for are there ? what is cte and explain it
Starting from data types analytic functions cursors/procedures/functions collections indexes tuning Few general SQL queries - (pulling top 2/3 sal) Partitions - I missed this
Viewing 601 - 610 interview questions
See Interview Questions for Similar Jobs
Desarrollador De Formularios E Informes De OracleDesarrollador De OracleDba De Oracle SeniorAdministrador De Base De Datos De Aplicaciones OracleAplicaciones Oracle DbaAdministrador De Base De Datos De Aplicaciones De Oracle SeniorDesarrollador De Aplicaciones Oracle SeniorConsultor De Oracle Business Intelligence Suite Edición EmpresarialDesarrollador De Aplicaciones Oracle JuniorAnalista Desarrollador De Objetos De Negocios Administrador De HadoopDesarrollador De Objetos De Negocio Trabaja Desde CasaMainframe Db2 Sistema De Gestión De Bases De Datos RelacionalesAnalista Financiero De OracleConsultor De Big Data De HadoopAnalista De Sistemas Financieros De OracleGerente De Base De Datos De Aplicaciones Y Productos Del SistemaDesarrollador De Oracle Pl Lenguaje De Consulta Estructurado Senior