Featured post

4 Layers of AWS Architecture a Quick Answer

I have collected real interview questions on AWS key architecture components. Those are S3, EC2, SQS, and SimpleDB. AWS is one of the most popular skills in the area of Cloud computing. Many companies are recruiting software developers to work on cloud computing.

AWS Key Architecture Components AWS is the top cloud platform. The knowledge of this helpful to learn other cloud platforms. Below are the questions asked in interviews recently.
What are the components involved in AWS?Amazon S3.With this, one can retrieve the key information which is occupied in creating cloud structural design, and the amount of produced information also can be stored in this component that is the consequence of the key specified.Amazon EC2. Helpful to run a large distributed system on the Hadoop cluster. Automatic parallelization and job scheduling can be achieved by this component.Amazon SQS. This component acts as a mediator between different controllers. Also worn for cushioning requirements those are obt…

PL/SQL Sample code and error handling mechanism

SAMPLE PL/SQL


CREATE TABLE dummy
( dummy_value       VARCHAR2(1));
DECLARE
  -- Define local variable.
  my_string VARCHAR2(1) := ' ';
  my_number NUMBER;
BEGIN
  -- Select a white space into a local variable.
  SELECT ' ' INTO my_string FROM dummy;
  -- Attempt to assign a single white space to a number.
  my_number := TO_NUMBER(my_string);
EXCEPTION
 WHEN no_data_found THEN
   dbms_output.put_line('SELECT-INTO'||CHR(10)||SQLERRM);
END;
/

Output and Error:
The program returns the following output, which illustrates formatting user- defined exceptions. 

The CHR(10) inserts a line return and provides a clean break between the program's SQLCODE and SQLERRM messages:

RAISE my_error SQLCODE [1] 
SQLERRM [User-Defined Exception]

Comments

Popular posts from this blog

Hyperledger Fabric: 20 Real Interview Questions

Python IF Statements Multiple Conditions Examples

Best Machine Learning Book for Beginners