Ops$tkyte%ORA11GR2> rollback to savepoint x_100 Īlso - snapshots are the name materialized views were formally known as. Ops$tkyte%ORA11GR2> rollback to savepoint x_500 Ops$tkyte%ORA11GR2> select max(x) from t Ops$tkyte%ORA11GR2> create table t ( x int ) A simple example demonstrates "five" is not even close to reality: Oracle has never had "bcp".Īlso, you are wrong about five savepoints. Its a SQL Server/Sybase tool.Īs someone else pointed out, BCP is a command line tool for sql server/sybase. What is init.ora file, where does it used, when it is read?ĭifference beween segment, schema and table in Oracle database?īCP doesn't exists in Oracle. How does a Query executes in Oracle? Can you list steps involved?įollowing steps are involved in parsing SQL query : Index is normally used to improve SQL query performance. In Windows, you can defined it under user defined environment variable.Īn index is a database object which is applied to a column to make searching easy in database.
![pl sql developer interview questions and answers pl sql developer interview questions and answers](https://m.media-amazon.com/images/S/aplus-media/kdp/85eff40f-6792-46cf-8f8d-f2e7168f6d4d.__CR0,0,2500,773_PT0_SX970_V1___.jpg)
Location of Oracle installation folder in disk.
![pl sql developer interview questions and answers pl sql developer interview questions and answers](https://www.acte.in/wp-content/uploads/2020/06/Oracle-Interview-Questions-and-Answers-ACTE.png)
What is $ORACLE_BASE and where it is defined? $ORACLE_BASE is similar to $JAVA_HOME, it's an environment variable points to the I was looking for some short Oracle database questions for telephonic round of interview, but didn't find any good list, so end up creating my own.Įxplain plan describe the execution plan choosen to execute a SQL query by Query Engine. You need use chracter function to do this. Write a SQL Statement to the show the following output exactly in multiple lines? (EXTRACT(MONTH FROM TO_DATE('', 'DD/MM/YYYY')) - EXTRACT(MONTH FROM TO_DATE('', 'DD/MM/YYYY'))) NUM_OF_MONTHSĥ. SELECT EXTRACT(MONTH FROM TO_DATE('', 'DD/MM/YYYY')) TRADE_MONTH,ĮXTRACT(MONTH FROM TO_DATE('', 'DD/MM/YYYY')) MATURITY_MONTH, Similarly, you can find MONTH from DATE and calculate number of months between them : (EXTRACT(YEAR FROM TO_DATE('', 'DD/MM/YYYY')) - EXTRACT(YEAR FROM TO_DATE('', 'DD/MM/YYYY'))) NUM_OF_YEARS SELECT EXTRACT(YEAR FROM TO_DATE('', 'DD/MM/YYYY')) TRADE_YEAR,ĮXTRACT(YEAR FROM TO_DATE('', 'DD/MM/YYYY')) MATURITY_YEAR, By the way, you can also use EXTRACT function to find number of months, years between two dates, as follows :Įxtracting YEAR from DATE, and finding number of YEARS between dates : So, they were pretty detailed and touching different aspect of date and time in Oracle.ġ) How do you find MONTH and YEAR from a date in Oracle?Īnswer : By using EXTRACT function, you can use it to get MONTH and YEAR from a DATE object.
#PL SQL DEVELOPER INTERVIEW QUESTIONS AND ANSWERS HOW TO#
As follow-up they asked me how to find number of months between two dates. I was asked to find number of days between two dates in Java, and questions like find the orders which are more than one months old or 15 days old. I think, most popular question on Oracle interviews are, How to find difference between two dates in Oracle database? Can you please provide multiple answers for this question, and also reasoning behind, choosing best way to do that? You can more get mysql interview questions & answers on :
![pl sql developer interview questions and answers pl sql developer interview questions and answers](https://www.besanttechnologies.com/wp-content/uploads/2018/12/sql-server-dba-interview-questions.jpg)
I have often greeted with this question in Oralce interviews, Which version of Oracle database do you use? and difference between two version of Oracle database e.g.