String in Pl/SQL

 String in Pl/SQL



1. What is String?

  • Definition : A sequence of characters
  • The characters could be numeric, letters, blank, special characters or a combination of all.
Note : -- is used as single line comment in PL/SQL.

2. Question: Print "Hello World" in PL/SQL.

Program 1:

DECLARE

str VARCHAR2(25);

BEGIN

str:= 'Hello World';

dbms_output.put_line (str);

END;

/

Output: Hello World




Note : Single quotes are used to indicate the beginning and end of a string in SQL. Double quotes generally aren't used in SQL but vary from database to database.

Program 2:

DECLARE

str VARCHAR2(25);

BEGIN

str:= "Hello World";

dbms_output.put_line (str);

END;

/


Output:

ERROR at line 4:

ORA-06550: line 4, column 8:

PLS-00201: identifier 'Hello World' must be declared

ORA-06550: line 4, column 1:

PL/SQL: Statement ignored


3. Write a PL/SQL code to print ASCII value of string in PL/SQL.

Program 1: 

DECLARE

str VARCHAR2(25);

BEGIN

str:= 'A';

dbms_output.put_line (ASCII(str));

END;

/


Output : 65


Program 2: 

DECLARE

str VARCHAR(25);

result INTEGER;

BEGIN

str:='a';

result:=ASCII(str);

dbms_output.put_line(result);

END;

 /


Program 3: 

DECLARE

str VARCHAR2(25);

BEGIN

str:= 'Hello World';

dbms_output.put_line (ASCII(str));

END;

/


Output : 72 

Because it will take first character : H 


4. Write a PL/SQL code to convert ASCII value to Character.

Program 2: 

--To covert number to ASCII Value

BEGIN

dbms_output.put_line (CHR(65));

END;

/


Output : A 


5. Write a PL/SQL code to append/concat the string.

Syntax : concat(str1,str2)

Program :

--To append/concat the string in pl/sql

DECLARE

str1 VARCHAR2(25);

str2 VARCHAR2(25);


BEGIN

str1 := 'Hello';

str2 := 'World';


dbms_output.put_line (CONCAT(str1,str2));

END;

/

Output : Hello World


6. Write a PL/SQL code to convert the first character in uppercase .

Syntax : concat(str1,str2)

Program :

--To convert the first character in uppercase

DECLARE

str1 VARCHAR2(25);

BEGIN

str1 := 'hello';

dbms_output.put_line (INITCAP(str1));

END;

/


Output:

Hello


7. Write a PL/SQL code to convert the string  in uppercase.

Program :

--To convert the string in uppercase

DECLARE

str1 VARCHAR2(25);


BEGIN

str1 := 'hello';


dbms_output.put_line (upper(str1));

END;

/


Output : HELLO


8. Write a PL/SQL code to count the string .

Program :

--To count the string 


DECLARE

str1 VARCHAR2(25);


BEGIN

str1 := 'HELLO';


dbms_output.put_line (length(str1));

END;

/

Output : 5



9. Write a PL/SQL code to retrieve the remainder of the string starting from the third position.

Program:

--Retrieve the remainder of the string starting from the third position.

DECLARE

str1 VARCHAR2(25);


BEGIN

str1 := 'HELLO';


dbms_output.put_line ( SUBSTR (str1, 3));

END;

/


Output: LLO


10. Write a PL/SQL code to find the location of the character.

Program 1:

-- find the location of the character
DECLARE
str1 VARCHAR2(25);

BEGIN
str1 := 'HELLO';

dbms_output.put_line ( INSTR  (str1,'E'));
END;
/

Output : 2


Program 2:

-- find the location of the character
DECLARE
str1 VARCHAR2(25);

BEGIN
str1 := 'HELLO';

dbms_output.put_line ( INSTR  (str1,'L'));
END;
/

Output : 3

More Program Will Be Updated Soon,
Stay Connected.

Thank-you

Comments

Post a Comment

Popular posts from this blog

How to set image in carousel using flask?

Image
How to set image in carousel using flask? Step 1: Create one folder on the desktop called my Flask . Step 2: Create Two folder called static and templates  in the myFlask folder. Create one file called main.py   in the myFlask folder. Step 3: Add the code in the main.py file.      from flask import Flask,render_template      app = Flask(__name__)      @app.route('/')      def hello_world():          return render_template("index.html")      app.run(debug=True) Step 4: Create image folder in the static folder. Add one image  in the image folder. [arya.png]. Step 5: Create index.html in the templates folder and add the below code in that folder. <html> . . . <div id= "carouselExampleSlidesOnly" class= "carousel slide" data-ride= "carousel" > <div class= "carousel-inner" > <div class= "carousel-item active" > <img src= "{{url_for('st...
Read more

Invalid syntax , perhaps you forgot a comma? Error in Python

Image
Invalid syntax , perhaps you forgot a comma? Error n Python Problem : Invalid syntax , perhaps you forgot a comma? Error in Python Solution 1: May be you  have missed the assignment operator."="  Example: Solution 2: May be you have missed the comma between value or variable","  Example: Still Problem is not solved? For any queries, you can contact us: 📬 Contact Me 📞 Phone:  +918431334381 💬 WhatsApp:  +918431334381 📧 Email:   aryadrj@gmail.com 📝 Form:   Click here to fill out the form
Read more

How to run PL/SQL Code With Command Line?

Image
How to run PL/SQL Code With Run SQL Command Line? So What is PL/SQL? PL/SQL is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database, Times Ten in-memory database, and IBM DB 2.  In Simple Word PL/SQL means instructing the compiler 'what to do' through SQL and 'how to do' through its procedural way.  Follow these steps to run the code of PL/SQL with SQL command Line. Step 1: Type this in command prompt: connect sys as sysdba Enter password: wb Connected. Step 2: We need to type and execute "set serveroutput on" if  to see the output of the program. Step 3: Type this Sample Code: set serveroutput on BEGIN dbms_output.put_line ('Hello World..'); END; / Step 4: You will get output: Hello World Thank-you. Also Read : String in PL/SQL.
Read more