Monday, June 30, 2014

51 ORACLE SQL PL/SQL INTERVIEW QUESTIONS

Hi Guys, I have come up with my new post to put Oracle interview questions which I came across during my interview with various companies. I believe that this post will be helpful to freshers as well as experience candidate in interview. These interview questions are mostly straight forward. I will come up with more tricky questions later. Please post your comments and suggestions ,which will make learning better for all. Some questions are having answer and some are not in below list of questions .You can post queries and doubts related with questions below, so I can answer them. Please let me know if you like the post, so you can see more post on Oracle!

Keep Sharing,Keep Learning guys :)

51 Oracle Interview Questions and Answers -

1. Reference Cursor ? A reference cursor is a pointer to a memory location that can be passed between different PL/SQL clients, thus allowing query result sets to be passed back and forth between clients. A reference cursor is a variable type defined using the PL/SQL TYPE statement within an Oracle package, much like a PL/SQL table: TYPE ref_type_name IS REF CURSOR RETURN return_type; Here, ref_type_name is the name given to the type and return_type represents a record in the database. You do not have to specify the return type as this could be used as a general catch-all reference cursor. Such non-restrictive types are known as weak, whereas specifying the return type is restrictive, or strong. The following example uses %ROWTYPE to define a strong return type that represents the record structure of the emp table: DECLARE TYPE EmpCurType IS REF CURSOR RETURN emp%ROWTYPE; ================================================================================ 2. Anonymous Block ? An unnamed PL/SQL block is called an anonymous block. A PL/SQL block contains three parts or sections. They are: • The optional Declaration section. • The mandatory Execution section. • The optional Exception (or Error) Handling section. ================================================================================ 3. Explain how cursor is implemented in PL/SQL A cursor is a variable that runs through the rows of some table or answer to some query. CURSOR employee_cur IS SELECT * FROM employee; Once I have declared the cursor, I can open it: OPEN employee_cur; And then I can fetch rows from it: FETCH employee_cur INTO employee_rec; and, finally, I can close the cursor: CLOSE employee_cur; *********** DECLARE CURSOR joke_feedback_cur IS SELECT J.name, R.laugh_volume, C.name FROM joke J, response R, comedian C WHERE J.joke_id = R.joke_id AND J.joker_id = C.joker_id; BEGIN ... END; ================================================================================ 4. Constraints ? Integrity constraints are used to enforce Business logic. Enforcing rules with integrity constraints is less costly than enforcing the equivalent rules by issuing SQL statements in the application. Only define NOT NULL constraints for columns of a table that absolutely require values at all times. Use the combination of NOT NULL and UNIQUE key integrity constraints to force the input of values in the UNIQUE key; this combination of data integrity rules eliminates the possibility that any new row's data will ever attempt to conflict with an existing row's data. Choosing a Table's Primary Key : Each table can have one primary key. A primary key allows each row in a table to be uniquely identified and ensures that no duplicate rows exist. Use the following guidelines when selecting a primary key: Choose a column whose data values are unique. The purpose of a table's primary key is to uniquely identify each row of the table. Therefore, the column or set of columns in the primary key must contain unique values for each row. Choose a column whose data values are never changed. A primary key value is only used to identify a row in the table; primary key values should never contain any data that is used for any other purpose. Therefore, primary key values should rarely need to be changed. Choose a column that does not contain any nulls. A PRIMARY KEY constraint, by definition, does not allow the input of any row with a null in any column that is part of the primary key. Choose a column that is short and numeric. Short primary keys are easy to type. You can use sequence numbers to easily generate numeric primary keys. Avoid choosing composite primary keys. Although composite primary keys are allowed, they do not satisfy the previous recommendations. For example, composite primary key values are long and cannot be assigned by sequence numbers. Foreign Key(Referential Integrity): Whenever two tables are related by a common column (or set of columns), define a PRIMARY or UNIQUE key constraint on the column in the parent table, and define a FOREIGN KEY constraint on the column in the child table, to maintain the relationship between the two tables. Using CHECK Integrity Constraints Use CHECK constraints when you need to enforce integrity rules that can be evaluated based on logical expressions. Never use CHECK constraints when any of the other types of integrity constraints can provide the necessary checking. *The condition must be a Boolean expression that can be evaluated using the values in the row being inserted or updated. *The condition cannot contain subqueries or sequences. *The condition cannot include the SYSDATE, UID, USER, or USERENV SQL functions. *The condition cannot contain the pseudocolumns LEVEL, PRIOR, or ROWNUM; *The condition cannot contain a user-defined SQL function. Eg. CREATE TABLE dept ( deptno NUMBER(3) PRIMARY KEY, dname VARCHAR2(15), loc VARCHAR2(15), CONSTRAINT dname_ukey UNIQUE (dname, loc), CONSTRAINT loc_check1 CHECK (loc IN ('NEW YORK', 'BOSTON', 'CHICAGO'))); ================================================================================ 5. Difference between Primary Key and Unique key ? * Primary keys are used to identify each row of the table uniquely. Unique keys should not have the purpose of identifying rows in the table. * A primary key field cannot be Null, whereas a Unique column can have a Null value. * There could be only 1 Primary Key per table, but there could be any number of Unique Key columns. * A primary key should be a Unique column, but all Unique Key column need not be a PRimary Key ================================================================================ 6. what are diffenent Joins explain . outer ? how would you write outer join(=+) if specify + to the right of equal to sign, which table data will be in full. A join is a query that combines rows from two or more tables. An equijoin is a join with a join condition containing an equality operator. ( where A.b = C.d) A self join is a join of a table to itself. Cartesian Products If two tables in a join query have no join condition, then Oracle returns their Cartesian product. Oracle combines each row of one table with each row of the other. A Cartesian product always generates many rows and is rarely useful. For example, the Cartesian product of two tables, each with 100 rows, has 10,000 rows. Always include a join condition unless you specifically need a Cartesian product. If a query joins three or more tables and you do not specify a join condition for a specific pair, then the optimizer may choose a join order that avoids producing an intermediate Cartesian product. An inner join (sometimes called a "simple join") is a join of two or more tables that returns only those rows that satisfy the join condition. An outer join returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition. To write a query that performs an outer join of tables A and B and returns all rows from A( left outer join), apply the outer join operator (+) to all columns of B in the join condition. For example, SELECT ename, job, dept.deptno, dname FROM emp, dept WHERE emp.deptno (+) = dept.deptno; will select all departments even if there is no employee for a particular dept. Similarly to get all rows from B form a join of A & B , apply the outer join operator(+) to A. Example, SELECT ename, job, dept.deptno, dname FROM emp, dept WHERE emp.deptno = dept.deptno (+) ================================================================================ 7. Is a function in SELECT possible ? Yes. FOr example, Select ltrim(price) from Item. User defined functions work only from Oracle 8i onwards. ================================================================================ 8. EXCEPTION handling in PL/SQL An exception is a runtime error or warning condition, which can be predefined or user-defined. Predefined exceptions are raised implicitly (automatically) by the runtime system. User-defined exceptions must be raised explicitly by RAISE statements. To handle raised exceptions, you write separate routines called exception handlers. Example of an exception handler: DECLARE pe_ratio NUMBER(3,1); BEGIN SELECT price / earnings INTO pe_ratio FROM stocks WHERE symbol = 'XYZ'; -- might cause division-by-zero error INSERT INTO stats (symbol, ratio) VALUES ('XYZ', pe_ratio); COMMIT; EXCEPTION -- exception handlers begin WHEN ZERO_DIVIDE THEN -- handles 'division by zero' error INSERT INTO stats (symbol, ratio) VALUES ('XYZ', NULL); COMMIT; ... WHEN OTHERS THEN -- handles all other errors ROLLBACK; END; -- exception handlers and block end here Unlike predefined exceptions, user-defined exceptions must be declared and must be raised explicitly by RAISE statements. Example: DECLARE past_due EXCEPTION; acct_num NUMBER; BEGIN ... ... IF ... THEN RAISE past_due; -- this is not handled END IF; EXCEPTION WHEN past_due THEN -- does not handle RAISEd exception WHEN OTHERS THEN -- handle all other errors END; The procedure RAISE_APPLICATION_ERROR lets you issue user-defined ORA- error messages from stored subprograms. That way, you can report errors to your application and avoid returning unhandled exceptions. To call RAISE_APPLICATION_ERROR, use the syntax raise_application_error(error_number, message[, {TRUE | FALSE}]); where error_number is a negative integer in the range -20000 .. -20999 and message is a character string up to 2048 bytes long. If the optional third parameter is TRUE, the error is placed on the stack of previous errors. If the parameter is FALSE (the default), the error replaces all previous errors. RAISE_APPLICATION_ERROR is part of package DBMS_STANDARD, and as with package STANDARD, you do not need to qualify references to it. An application can call raise_application_error only from an executing stored subprogram (or method). When called, raise_application_error ends the subprogram and returns a user-defined error number and message to the application. The error number and message can be trapped like any Oracle error. Another way to handle exception is to use DECODE statements. For example: INSERT INTO stats (symbol, ratio) SELECT symbol, DECODE(earnings, 0, NULL, price / earnings) FROM stocks WHERE symbol = 'XYZ'; Here the DECODE function checks whether the earnings is 0 and if it is zero, then returns earnings, else price/earnings. ================================================================================ 9. When an exception is triggered in a loop, how you continue to next itereration ? By having an exception andling block within the loop. ================================================================================ 10. Decode ? Using Decode map this logic, If A>B Display 'A is Big', If A=B Display 'A equals B' Else 'B is Big' DECODE(Greatest(A,B), A, 'A is big', B, 'B is Big', 'A equals B') ================================================================================ 11. What is an index? what are diff type of indices? what is Clustered and Non Clustered Indeces ? Indexing is typically listing of keywords alongwith its location and is done to speed up the Data base. Create index WORKERSKILL_NAME_SKILL on WORKERSKILL(Name,Skill); A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages. A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows. ================================================================================ 12. Mutating Error ? When we use a row level triger on a table, and at the same time if we query/insert/delete/update on the same table, it will give the mutating error. ================================================================================ 13. How to avoid mutating error? Two possible solutions. 1. Change the design of the table so as to avoid querying or any update on the table on which the row level trigger is holding on. 2. Create a package which holds a PL/SQL table with the RowID of the rows need to insert/update and a counter of the rows a. In BEFORE STATEMENT trigger set the counter to zero. b. In every ROW trigger call a procedure from the package which will register the RowId and modify the counter c. In AFTER STATEMENT trigger call a procedure which will make the needed checks and update the particular rows of the table. If you are not familiar with PL/SQL tables alternatively you can use temporary Oracle tables. It is also a good idea. ================================================================================ 14. Difference between Delete and Truncate. Truncate will permenantly delete the record and no rollback capability will exist. The delete command remove records from a table. Delete moves records to the rollback segment enabling rollback capability. Excessive use of triggers can result in complex interdependencies, which can be difficult to maintain in a large application. ================================================================================ 15. How many types of triggers are there and what are ? (Before Insert, after Insert, update, delete etc..) Triggers are similar to stored procedures. A trigger stored in the database can include SQL and PL/SQL or Java statements to run as a unit and can invoke stored procedures. However, procedures and triggers differ in the way that they are invoked. A procedure is explicitly run by a user, application, or trigger. Triggers are implicitly fired by Oracle when a triggering event occurs, no matter which user is connected or which application is being used. Different Types --------------- Row Triggers and Statement Triggers BEFORE and AFTER Triggers INSTEAD OF Triggers ( ON views,for INSERT etc, instaed of Inserting, it will carry out the trigger statements) Triggers on System Events(shut down) and User Events ( log on) ================================================================================ 16. What all composite datatypes in oracle Composite Data types: Table 1. Is similar but not the same as a database table 2. Must contain only one column of any scalar datatype 3. Is like a one-dimensional array of any size 4. Has its elements indexed with a binary integer column called the primary key of the table Record 1. Contains uniquely defined columns of different data types, 2. Enables us to treat dissimilar columns that are logically related as a single unit. ================================================================================ 17. what is PL/SQL tables? ================================================================================ 18. What are the default packages provided by oracle The ones with "DBMS_" prefix. Eg. DBMS_Output, DBMS_ALERT ================================================================================ 19. What is the diff between Where and Having Having clause is used where group by clasue is used to restrict the groups of returned rows to those groups for which the specified condition is TRUE. The HAVING condition cannot contain a scalar subquery expression eg: SELECT department_id, MIN(salary), MAX (salary) FROM employees GROUP BY department_id HAVING MIN(salary) < 5000; ================================================================================ 20. How is error Handling done? ================================================================================ 21. I have table that contains state codes, I might have more than 1 rows with the same state code, how can I find out? select count(*), state_code from table. IF this is > 1 , then we can assure that there are duplicates. ================================================================================ 22. How do you copy rows from Schema a , table p to table p in schema b ? To copy between tables on a remote database, include the same username, password, and service name in the FROM and TO clauses: COPY FROM HR/your_password@SchemaA - TO HR/your_password@SchemaB - INSERT tableP- USING SELECT * FROM tableP ================================================================================ 23. What is %Rowtype and %Type PROCEDURE Get_emp_names(Dept_num IN Emp_tab.Deptno%TYPE) ..Means the INput Parameter Dept_num should have the same Data Type as Emp_tab.DeptNo. Use the %ROWTYPE attribute to create a record that contains all the columns of the specified table. The following example defines the Get_emp_rec procedure, which returns all the columns of the Emp_tab table in a PL/SQL record for the given empno: PROCEDURE Get_emp_rec (Emp_number IN Emp_tab.Empno%TYPE, Emp_ret OUT Emp_tab%ROWTYPE) IS BEGIN SELECT Empno, Ename, Job, Mgr, Hiredate, Sal, Comm, Deptno INTO Emp_ret FROM Emp_tab WHERE Empno = Emp_number; END; You could call this procedure from a PL/SQL block as follows: DECLARE Emp_row Emp_tab%ROWTYPE; -- declare a record matching a -- row in the Emp_tab table BEGIN Get_emp_rec(7499, Emp_row); -- call for Emp_tab# 7499 DBMS_OUTPUT.PUT(Emp_row.Ename || ' ' || Emp_row.Empno); DBMS_OUTPUT.PUT(' ' || Emp_row.Job || ' ' || Emp_row.Mgr); DBMS_OUTPUT.PUT(' ' || Emp_row.Hiredate || ' ' || Emp_row.Sal); DBMS_OUTPUT.PUT(' ' || Emp_row.Comm || ' '|| Emp_row.Deptno); DBMS_OUTPUT.NEW_LINE; END; ================================================================================ 24. How to use the cursor with using open, fetch and close.? ================================================================================ 25. using select Statement how you will retrieve the user who is logged in? SELECT SYS_CONTEXT ('USERENV', 'SESSION_USER') FROM DUAL; ================================================================================ 26. When Exception occurs, i want to see the error generated by Oracle. How to see it? SQLERRM ================================================================================ 27. how to generate the out of the select statement in a file? SPOOL ================================================================================ 28. how to find the duplicate records? select count(*), job from emp group by job having count(*) > 1 then there are duplicates. ================================================================================ 29. What is Procedure, function, package and anonymous block? Procedures are named groups of SQl statements. Functions are like Procedures, but can return a value. Packages are groups of procedures, functions, variables and SQL statements. An unnamed PL/SQL block is called an anonymous block. ================================================================================ 30. What is group by funcion and where it is used.? Specify the GROUP BY clause if you want Oracle to group the selected rows based on the value of expr(s) for each row and return a single row of summary information for each group. Expressions in the GROUP BY clause can contain any columns of the tables, views, or materialized views in the FROM clause, regardless of whether the columns appear in the select list. It is used for aggraegate functions. ================================================================================ 31. What is the difference between RDBMS and DBMS? Sol: Chords 12 rules. ================================================================================ 32. What is normalised and denormalised data? process of removing redundancy in data by separating the data into multiple tables. ================================================================================ 33. What is a VIEW? A view is a custom-tailored presentation of the data in one or more tables. A view can also be thought of as a "stored query." Views do not actually contain or store data; they derive their data from the tables on which they are based. ================================================================================ 34. Can a view update a table? Can, but with restrictions. Like tables, views can be queried, updated, inserted into, and deleted from, with some restrictions. All operations performed on a view affect the base tables of the view. ================================================================================ 35. What happens if there is an exception in the cursor? How do we ensure that the execution for other records in the cursor does not stop. ================================================================================ 36. What are cursors ? After retrieving the records into the cursor can we update the record in the table for the retrieved record. What effect will it have on the cursor? Cursors Oracle uses work areas to execute SQL statements and store processing information. A PL/SQL construct called a cursor lets you name a work area and access its stored information. There are two kinds of cursors: implicit and explicit. PL/SQL implicitly declares a cursor for all SQL data manipulation statements, including queries that return only one row. For queries that return more than one row, you can explicitly declare a cursor to process the rows individually. An example follows: DECLARE CURSOR c1 IS SELECT empno, ename, job FROM emp WHERE deptno = 20; The set of rows returned by a multi-row query is called the result set. Its size is the number of rows that meet your search criteria Multi-row query processing is somewhat like file processing. For example, a COBOL program opens a file, processes records, then closes the file. Likewise, a PL/SQL program opens a cursor, processes rows returned by a query, then closes the cursor. Just as a file pointer marks the current position in an open file, a cursor marks the current position in a result set. You use the OPEN, FETCH, and CLOSE statements to control a cursor. The OPEN statement executes the query associated with the cursor, identifies the result set, and positions the cursor before the first row. The FETCH statement retrieves the current row and advances the cursor to the next row. When the last row has been processed, the CLOSE statement disables the cursor. ================================================================================ 37. What are user defined data types ? SUBTYPE subtype_name IS base_type; Eg. SUBTYPE EmpDate IS DATE; -- based on DATE type SUBTYPE ID_Num IS emp.empno%TYPE; -- based on column type CURSOR c1 IS SELECT * FROM dept; SUBTYPE DeptFile IS c1%ROWTYPE; -- based on cursor rowtype To specify base_type, you can use %TYPE, which provides the datatype of a variable or database column. Also, you can use %ROWTYPE, which provides the rowtype of a cursor, cursor variable, or database table. A subtype does not introduce a new type; it merely places an optional constraint on its base type. ================================================================================ 38. How to copy the Structure and data from one table to another in one SQL stmt? COPY {FROM database | TO database | FROM database TO database} {APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column, column, ...)] USING query where database has the following syntax: username[/password]@connect_identifier ================================================================================ 39. Describe UNION and UNION ALL. UNION returns distinct rows selected by both queries while UNION ALL returns all the rows. Therefore, if the table has duplicates, UNION will remove them. If the table has no duplicates, UNION will force a sort and cause performance degradation as compared to UNION ALL. ================================================================================ 40. What is 1st normal form? Each cell must be one and only one value, and that value must be atomic: there can be no repeating groups in a table that satisfies first normal form. ================================================================================ 41. What is 2nd normal form? Every nonkey column must depend on the entire primary key. ================================================================================ 42. What is 3rd normal form? (another explanation than #1) No nonkey column depends on another nonkey column. ================================================================================ 43. What is 4th normal form? Fourth normal form forbids independent one-to-many relationships between primary key columns and nonkey columns. ================================================================================ 44. What is 5th normal form? Fifth normal form breaks tables into the smallest possible pieces in order to eliminate all redundancy within a table. Tables normalized to this extent consist of little more than the primary key. 45. How to find out top n salary from a employee table? ================================================================================ 46.If we will modify a function , which is defined in package even though stored package will be valid ? ================================================================================ 47.How do you define public and private procedure in oracle? ================================================================================ 48.If same kind of logic we put in function as well as procedure then which one will be faster? ================================================================================ 49.If we deleted any rows in table and commited then is it possible to retrieve the deleted data? ================================================================================ 50. While handiling excecption if we have written “When others then” first before other exception handler then what will happen? ================================================================================ 51. What is sql injection attack???
<form method="post" action="http://testasp.vulnweb.com/login.asp">
<input name="tfUName" type="text" id="tfUName">
<input name="tfUPass" type="password" id="tfUPass">
</form>
The easiest way for the login.asp to work is by building a database query that looks like this:
SELECT id
FROM logins
WHERE username = '$username'
AND password = '$password’

If the variables $username and $password are requested directly from the user's input, this can easily be compromised. Suppose that we gave "Joe" as a username and that the following string was provided as a password: anything' OR 'x'='x
SELECT id
FROM logins
WHERE username = 'Joe'
AND password = 'anything' OR 'x'='x'

As the inputs of the web application are not properly sanitised, the use of the single quotes has turned the WHERE SQL command into a two-component clause.
The 'x'='x' part guarantees to be true regardless of what the first part contains.
This will allow the attacker to bypass the login form without actually knowing a valid username / password combination!


                                                            COPYRIGHT © 2013 TECH BRAINS

118 comments:

  1. Please post here if anyone has any doubt in above questions.

    Thanks,
    Uttam

    ReplyDelete
  2. Hi,Thanks for giving questions .It is very useful for interview purpose .
    Oracle Training in Chennai

    ReplyDelete
  3. Your blog is really useful for me. Thanks for sharing this informative blog. If anyone wants to get real time Oracle Course in Chennai reach FITA. They give professional and job oriented training for all students.

    ReplyDelete
  4. I get a lot of great information from this blog. Recently I did oracle certification course at a leading academy. If you are looking for best Oracle Training Chennai visit FITA IT training and placement academy which offer PL SQL Training in Chennai.

    ReplyDelete
  5. Nice set of questions..

    Besides this article, i have also found more interview questions in below article ..Hope that it will be helpful for you all :)

    http://youngnewton.com/top-20-sql-interview-questions/
    http://youngnewton.com/top-20-oracle-plsql-interview-questions/

    ReplyDelete
    Replies
    1. Marhaba,,


      Fully agree on #topic. We’re seeing a lot of projects tackle big complex problems but few seem to have taken into consideration and in particular reasons to adopt.


      I want to execute the different files at the run time in the SQL PLUS

      Ex: I have two different files like ABC.SQL, XYZ.SQL,

      I had declared one bind variable to hold file_name .

      var file_name VARCHAR2(200);
      DECLARE
      sr VARCHAR2(20) :='ABC';
      BEGIN
      IF sr ='ABC' THEN
      :file_name :='ABC.SQL';
      ELSE
      :file_name :='XYZ.SQL';
      END IF;
      END;
      /
      PRINT file_name


      Now i want to execute the file which is there in :file_name bind variable

      SQL>@:file_name



      It was cool to see your article pop up in my google search for the process yesterday. Great Guide.
      Keep up the good work!


      morgan

      Delete
  6. Hi Admin,
    This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.s
    Regards,
    sas training chennai|sas institutes in Chennai|sas training institutes in Chennai

    ReplyDelete
  7. Hello,
    I really enjoyed while reading your article, the information you have mentioned in this post was damn good. Keep sharing your blog with updated and useful information.
    Regards,
    Informatica training in chennai|Best Informatica Training In Chennai|Informatica training center in Chennai

    ReplyDelete
  8. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
    Regards,
    Oracle DBA Training in Chennai|Oracle apps Training in Chennai|Oracle Training

    ReplyDelete
  9. thank you but give me tricky questions & one more think that what was scope in orcale as dba or designers

    ReplyDelete
  10. very usefull thanq u so much....

    ReplyDelete
  11. Very useful information thank you for sharing. Know more about PLSQL Training in Bangalore

    ReplyDelete
  12. Pls share tricky questions for 6+ yrs experienced person

    ReplyDelete
  13. Thanks to shared this useful oracle interview questions with us. Keep updating.
    DBA course syllabus | DBA training courses

    ReplyDelete
  14. Hi There,


    Great info! I recently came across your blog and have been reading along.
    I thought I would leave my first comment. I don’t know what to say except that I have


    I created a unix shell in Unix AIX which rebuild indexes in db2.
    The problem is that I want to call that .sh file from SSIS 2008 r2, but I didn't found solution since tasks in SSIS 2008R2 only recognize exe files.

    It was cool to see your article pop up in my google search for the process yesterday. Great Guide.
    Keep up the good work!


    Gracias
    Irene Hynes

    ReplyDelete
  15. Hello There,


    That’s how speedy and easy this read was! Looking forward to more of such powerful content on ORACLE SQL PL/SQL INTERVIEW QUESTIONS

    I need your help please, I am new at PL/SQL

    I need to run a select command with multiple values, if a break down this query into 3 pieces and run them, they works perfectly but I've got problems whenever I execute this query because there are multiple values into the where clause and I think it's necessary to create lines break so it may work perfectly


    Thank you very much and will look for more postings from you.


    Regards,
    Bindu

    ReplyDelete
  16. I ‘d mention that most of us visitors are endowed to exist in a fabulous place with very many wonderful individuals with very helpful things.
    Best Python training Institute in chennai

    ReplyDelete
  17. Hi There,

    I’ve often thought about this 51 ORACLE SQL PL/SQL INTERVIEW QUESTIONS . Nice to have it laid out so clearly. Great eye opener.

    Our project DBA Team is planning to migrate Oracle DB from version 11.2.0.4 to 12.2.0.1.
    Could you please let mw know what the ares which gets impacted from DB Development Team prospective.
    Our DBA Team will take care of up gradation.
    But I want to know any deprecated concepts/impacted ares in Higher version?
    Current Version :Oracle Database 11g
    Enterprise Edition Release 11.2.0.4.0 - 64bit Production

    Thanks a lot. This was a perfect step-by-step guide. Don’t think it could have been done better.

    Obrigado,
    Preethi.

    ReplyDelete
  18. This comment has been removed by the author.

    ReplyDelete
  19. Good Post, I am a big believer in posting comments on sites to let the blog writers know that they ve added something advantageous to the world wide web.

    python training in chennai | python training in bangalore

    python online training | python training in pune

    python training in chennai | python training in bangalore

    python training in tambaram

    ReplyDelete
  20. The post is written in very a good manner and it entails many useful information for me. I am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept.

    java training in omr

    java training in annanagar | java training in chennai

    java training in marathahalli | java training in btm layout

    java training in rajaji nagar | java training in jayanagar

    ReplyDelete
  21. Really nice experience you have. Thank you for sharing. It will surely be an experience to someone.
    python training in Bangalore
    python training in pune
    python online training
    python training in chennai

    ReplyDelete
  22. I appreciate your efforts because it conveys the message of what you are trying to say. It's a great skill to make even the person who doesn't know about the subject could able to understand the subject . Your blogs are understandable and also elaborately described. I hope to read more and more interesting articles from your blog. All the best.
    java training in chennai | java training in bangalore


    java training in tambaram | java training in velachery

    ReplyDelete
  23. Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts
    python online training
    python training in OMR
    python training in tambaram

    ReplyDelete
  24. Nice post. By reading your blog, i get inspired and this provides some useful information. Thank you for posting this exclusive post for our vision. 
    Data science course in tambaram | Data Science course in anna nagar
    Data Science course in chennai | Data science course in Bangalore
    Data Science course in marathahalli | Data Science course in btm

    ReplyDelete
  25. Big Thanks for this wonderful read. I enjoyed every little bit of reading and I have bookmarked your website to check out new stuff of your blog a must read blog.
    iOS Training in Chennai
    Loadrunner Training in Chennai
    Hadoop Training in Chennai
    software testing selenium training
    selenium testing training in chennai
    Best selenium training in chennai

    ReplyDelete
  26. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
    DevOps Training in Chennai
    DevOps course
    Best devOps Training in Chennai
    DevOps foundation certificate
    DevOps institute certification
    DevOps certification course

    ReplyDelete
  27. Thank you for this great article which conveyed a good information.keep more updates

    Xamarin Course
    Xamarin Training Course
    Xamarin Classes
    Best Xamarin Course

    ReplyDelete
  28. Thank you for sharing this wonderful information. Keep up the good work.
    Oracle Bpm Online Training

    ReplyDelete
  29. Thanks for sharing your info. I truly appreciate your efforts and I am waiting for your next post thank you once again.
    Oracle Osb Online Training

    ReplyDelete
  30. Very good article. I absolutely appreciate this website. Stick with it!
    Informatica Training Classes

    ReplyDelete
  31. Hi mates, its wonderful article about educationand entirely defined, keep it up all the time….
    Java Training Classes

    ReplyDelete
  32. But he’s trying none the less. I’ve been using Movable-type on several websites for about a year and am anxious about switching to another platform. I have heard great things about blogengine.net.
    safety courses in chennai

    ReplyDelete
  33. Awesome post. Really you are shared very informative concept... Thank you for sharing. Keep on updating...

    imedicalassistants
    Education

    ReplyDelete
  34. Thanks for your interesting ideas.the information's in this blog is very much useful
    for me to improve my knowledge.
    Selenium training near me
    Selenium Training in Chennai
    Selenium Training in Amjikarai
    Selenium Training Institutes in Vadapalani

    ReplyDelete
  35. Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.
    Java training in Bangalore |Java training in Rajaji nagar

    Java training in Bangalore | Java training in Kalyan nagar

    Java training in Bangalore | Java training in Kalyan nagar

    Java training in Bangalore | Java training in Jaya nagar

    ReplyDelete
  36. Marvelous and fascinating article. Incredible things you've generally imparted to us. Much obliged. Simply keep making this kind out of the post.

    Oracle PLSQL Training in Chennai
    Oracle PLSQL Training

    ReplyDelete
  37. This is a good post. This post give truly quality information. I’m definitely going to look into it. Really very useful tips are provided here. thank you so much. Keep up the good works.
    Android Development Course in Chennai
    Android app Development Course in Chennai
    Android Training Institute in Chennai
    AWS Certification Training in Chennai
    AWS Training near me
    AWS Training in Chennai

    ReplyDelete
  38. Hey, Wow all the posts are very informative for the people who visit this site. Good work! We also have a Website. Please feel free to visit our site. Thank you for sharing. Well written article Thank You for Sharing with Us project management training in chennai | project management certification online | project management course online |

    ReplyDelete
  39. Really it was an awesome article… very interesting to read…

    CEH Training In Hyderbad

    ReplyDelete
  40. You are doing a great job. I would like to appreciate your work for good accuracy

    MSBI Training in chennai

    ReplyDelete
  41. This comment has been removed by the author.

    ReplyDelete
  42. QuickBooks user. Hope, you liked your site. If any method or technology you can't understand, if that's the case your better option is that will make e mail us at our QuickBooks Payroll Support Phone Number

    ReplyDelete
  43. We offers you QuickBooks Tech Support Our technicians be sure you the security associated with the vital business documents. We have a propensity never to compromise utilizing the safety of one's customers.

    ReplyDelete
  44. QuickBooks Enterprise Support Number is sold as an all within one accounting package geared towards mid-size businesses that do not require to manage the accounting hassle by themselves. The many industry specific versions add cherry regarding the cake. For such adaptive accounting software, it really is totally acceptable to throw some issues at some instances. During those times, you do not worry most likely and just reach our QuickBooks Enterprise Support channel available for a passing fancy call.

    ReplyDelete
  45. Dial QuickBooks Payroll tech support number to ask for QuickBooks enhanced payroll support to fix payroll issues. We work for startups to small-scale, medium-sized to multinational companies. At AccountWizy, you will find well-qualified and trained accountants, Proadvisors who can handle such errors. QuickBooks Payroll Tech Support Phone Number is a way of contacting us for Intuit product and QuickBooks Payroll subscription.

    ReplyDelete
  46. You can further browse the contact information on how to Contact QuickBooks Phone Number. QuickBooks technical support team are active for only 5 days (Mon-Fri) in a week. The QuickBooks Technical Support Number is available these days from 6 AM to 6 PM.

    ReplyDelete
  47. You’ll have the ability to give us a call at any time for the moment support we tend to are accessible for you personally 24*7. QuickBooks Support Number talented team of professionals is invariably in a position to work with you whatever needs doing.

    ReplyDelete
  48. Since this application is becoming a catalyst to utilize more sophisticated equipment and tools with the improvement in accounting software technology. Thus, it is natural to tackle each one of these tech glitches with the best accounting software. You can troubleshoot QuickBooks errors with the Intuit QuickBooks support by dialing our QuickBooks Enterprise Tech Support Number.

    ReplyDelete
  49. Our research team is often prepared beforehand because of the most appropriate solutions which can be of good help much less time consuming. Their pre-preparedness helps them extend their hundred percent support to all the entrepreneurs along with individual users of QuickBooks Technical Support Phone Number As tech support executives for QuickBooks, we assure our round the clock availability at our technical contact number.

    ReplyDelete
  50. The Guidance And Support System QuickBooks Enterprise Technical Support Is Dedicated To Produce Step-By-Step Ways To The Issues Encountered By Existing And New Users.

    ReplyDelete

  51. The most frequent errors faced by the QuickBooks users is unknown errors thrown by QuickBooks software during the time of software update. To help you to fix the problem, you need to have a look at your internet and firewall setting, web browser setting and system time and date setting you can just contact us at QuickBooks Support Phone Number for instant assistance in QB issues.

    ReplyDelete
  52. Our team offers a complete financial solution for the account. So just call us on our QuickBooks error support telephone number and sharing your all sort of accounting worries with us, we will definitely help you with your best QuickBooks updates in addition to solve your all QuickBooks Support Phone Number errors.

    ReplyDelete
  53. As well as all our QuickBooks, you'll have the capability to explore the most notable quality solutions. Our trained and well-seasoned professionals are all set to greatly help through QuickBooks Support Number give you support 24 hours a day. Besides, we believe to help keep the high amount of safety given that questions are primarily handled carefully to keep the computer program.

    ReplyDelete
  54. Unneeded to mention, QuickBooks Tech Support Phone Number has given its utmost support to entrepreneurs in decreasing the purchase price otherwise we’ve seen earlier, however, an accountant wont to hold completely different accounting record files.

    ReplyDelete
  55. QuickBooks Tech Support Number Accounting Help is a 3rd party service provider that deals with all kinds of account problems. The goal of the website is to deliver problem-solving solutions to customers looking for answers. The website also handles a new kind of matters like for e.g. if you're facing problems downloading and installing QuickBooks or if perhaps your multi-user feature isn’t working properly etc.

    ReplyDelete
  56. You yourself don’t find out how much errors you are making. When this occurs it is actually natural to own a loss in operation. But, I will be at your side. In the event that you hire our service, you are receiving the very best solution. We're going to assure you as a result of the error-free service. QuickBooks Customer Service Number is internationally recognized. You have to started to used to understand this help.

    ReplyDelete
  57. The principal intent behind QuickBooks Support number would be to give you the technical help 24*7 so as with order in order to prevent wasting your productivity hours. It is completely a toll-free QuickBooks client Service variety that you won’t pay any call charges. Of course, QuickBooks is certainly one among the list of awesome package in the company world. The accounting the main many companies varies based on this package. You will find so many fields it covers like creating invoices, managing taxes, managing payroll etc. However exceptions are typical over, sometimes it creates the negative aspects and user wants QuickBooks Support Service help.

    ReplyDelete
  58. For starters, a small business can simply survive if it is making adequate profits to smoothly run the operations associated with the work. Our QuickBooks Tech Support Phone Number team will certainly show you in telling you about the profit projections in QuickBooks.

    ReplyDelete
  59. So when we know that QuickBooks Tech Support Number has its own great benefits and QuickBooks scan manager is one of the amazing attributes of QuickBooks to simply maintain your all documents. However, if you should be not using this amazing and most helpful QuickBooks accounting software, then you're definitely ignoring your organization success.

    ReplyDelete
  60. Here we are going to update you the way you'll be able to obtain QuickBooks enterprise support telephone number or simple suggestions for connecting QuickBooks Enterprise Technical Support Number. QuickBooks is financial software that will help small company, large business along with home users.

    ReplyDelete
  61. QuickBooks Payroll Tech Support Number: A new option to manage your employees’ salary and other payroll functions of this business. QuickBooks Payroll enables users to view and approve employee work time and process payroll within five minutes.

    ReplyDelete
  62. Many companies have now been saving a regular amount of cash away from opting QuickBooks Payroll to transfer the salary for his or her employees. Also, the payrolls are accurate and shall be cleared timely through QuickBooks Tech Support Phone Number.

    ReplyDelete
  63. What an amazing post, thank you for this mind-boggling post, my mate. Keep it up and keep posting more. QuickBooks Accounting Software is one of the most sought after accounting software used by small and medium-sized businesses. This software along with the beneficial features and functions is also host to several errors and bugs. Thus, to fix them instantly and get back on the track, you can dial and talk to experts at QuickBooks Contact Number 1-833-441-8848 for all the information.

    ReplyDelete
  64. This is an awesome post and I would like to extend my gratitude by sharing this post on different platforms. If you are looking for a reliable and an efficient accounting software contact our experts at QuickBooks Support Phone Number +1-833-441-8848 and educate yourself more about this amazing software and its unending beneficial features and functionalities.

    ReplyDelete
  65. Awesome content I must say! Keep writing like this. Further, if you want to manage your accounts without difficulty and spending so much time, use QuickBooks accounting software. It offers payroll management as well. Also, you can call QuickBooks Payroll Support Phone Number 1-877-282-6222 regarding support in payroll. Service is available round the clock.visit us: https://www.enetservepartners.com/quickbooks-payroll-support/

    ReplyDelete
  66. Hi! Superb blog. You have written an excellent, self-explained, and thought-provoking blog. Being a small-sized business owner, it can get tough for you to manage your business accounts on your own. With QuickBooks, you can easily keep track of your business accounts. If you want quick help for the software, reach our experts via QuickBooks Support Phone Number +1-844-232-O2O2.
    visit us:-https://www.mildaccounting.com/quickbooks-support-phone-number/

    ReplyDelete
  67. Great blog-post! Keep up the good work like this. Apart from this what you may find good is QuickBooks accounting software as it has tons of customization options and features. Moreover, you also get great support at QuickBooks Desktop Payroll Support Number 1-833-401-0204 available 24/7. Call us right away! Read more: https://tinyurl.com/u7js23l or visit us: https://www.mildaccounting.com/quickbooks-desktop-payroll-support-number/

    ReplyDelete
  68. Facing any sort of discrepancy? You can't able to catch what happened to your software. Our QuickBooks Support Number 1-833-780-0086 is always there to help you out in resolving the QuickBooks issue. Gain eminent aid regarding software installation to further instruction & fixing error issues. For More Visit: https://g.page/quickbooks-support-california

    ReplyDelete
  69. wonderful post. your content is very useful for me. I also suggest quickbooks support number for quickbooks users for fix quickbooks issues.

    ReplyDelete
  70. Banking errors such as Error 9999 can be caused mainly because of several factors which make it important to troubleshoot every possible cause to prevents it from recurring. If you would like to learn How To Resolve Quickbooks Error 9999, you can continue reading this blog.

    ReplyDelete
  71. A minor/major security setting update is done by the bank that requires re-connection with the bank so that the updated settings can be taken correctly. If you would like to learn How To Troubleshoot Quickbooks Error 9999, you can continue reading this blog.

    ReplyDelete
  72. Nice tutorial. Thanks for sharing the valuable information. it’s really helpful. Who want to learn this blog most helpful. Keep sharing on updated tutorials… nice page
    Ai & Artificial Intelligence Course in Chennai
    PHP Training in Chennai
    Ethical Hacking Course in Chennai Blue Prism Training in Chennai
    UiPath Training in Chennai

    ReplyDelete
  73. This comment has been removed by the author.

    ReplyDelete
  74. This comment has been removed by the author.

    ReplyDelete
  75. This comment has been removed by the author.

    ReplyDelete
  76. Very nice posts. this could not be explained better. Thanks for sharing, Keep up the good work. Thanks for sharing your informative post on development.Your work is very good and I appreciate you and hoping for some more informational posts.keep writing and sharing.
    Salesforce Training in Chennai

    Salesforce Online Training in Chennai

    Salesforce Training in Bangalore

    Salesforce Training in Hyderabad

    Salesforce training in ameerpet

    Salesforce Training in Pune

    Salesforce Online Training

    Salesforce Training

    ReplyDelete
  77. 매우 유용한 데이터를 제공합니다. 이 게시물은 나에게 매우 유용하다는 많은 조언을 제공합니다. 몇 가지 문제를 해결하는 데 큰 도움이됩니다. 유용한 기사를 공유해 주셔서 대단히 감사합니다.
    내 사이트를 방문하십시오.파워볼사이트
    많은 정보를 얻을 수 있습니다.

    ReplyDelete
  78. Infycle Technologies, the best software training institute in Chennai offers the No.1 Big Data Training in Chennai for tech professionals. Apart from the Big Data training, other courses such as Oracle, Java, Hadoop, Selenium, Android, and iOS Development, Data Science will also be trained with 100% hands-on training. After the completion of training, the students will be sent for placement interviews in the core MNC's. Dial 7502633633 to get more info and a free demo.No.1 Big Data Training Chennai | Infycle Technologies

    ReplyDelete
  79. UNIQUE ACADEMY FOR COMMERCE, an institute where students enter to learn and leave as invincible professionals is highly known for the coaching for CA and CS aspirants.

    cs executive
    freecseetvideolectures/
    UNIQUE ACADEMY

    ReplyDelete
  80. https://teckgadgetzs.blogspot.com/2014/07/the-best-unit-converter-app-for-android.html?showComment=1633414469962#c3543863709823176774

    ReplyDelete
  81. Grab the Digital Marketing Training in Chennai from Infycle Technologies, the best software training institute, and Placement center in Chennai which is providing professional software courses such as Data Science, Artificial Intelligence, Cyber Security, Big Data, Java, Hadoop, Selenium, Android, and iOS Development, DevOps, Oracle etc with 100% hands-on practical training. Dial 7502633633 to get more info and a free demo and to grab the certification for having a peak rise in your career.

    ReplyDelete
  82. Mobile Forex Trading With Its Cutting Edge Platform Is Uniquely Qualified To Help Asset Managers And Their Broker Partners Meet This Challenge By Providing Low-cost, High-performance, And Highly-scalable Technical Trading Capabilities.

    ReplyDelete
  83. Oh my goodness! Impressive article dude! Thanks, PLease Check my article also.

    Mod Apk and Games

    ReplyDelete
  84. Oh my goodness! Impressive article dude! Thanks, PLease Check my article also.

    Seekhlo Tech

    ReplyDelete

Tricky Python Interview Questions and Answers Code - (Level 1)

1. Compress the String as below using Python code  :  Sample Input - 1222311 Sample Output - (1, 1) (3, 2) (1, 3) (2, 1) Explanation - First...