Oracle/plsql

Advertisement


Begum Saheba wrote at 2014-12-22 06:47:28
modify any one of the following line ur program will be definetly  run & also u get the output

In line 6:

varchar2(200) := 'select * from employees ';--give a space after table name i.e employees.



In line 10:

stmt := stmt || ' where DEPARTMENT_ID = :v_deptno';--give a space before where clause.


Oracle

All Answers


Answers by Expert:


Ask Experts

Volunteer


Suchitra Joshi

Expertise

I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.

Experience

15+ years of Oracle PL/SQL Development

Education/Credentials
B.Sc (Electronics), Diploma in Computer Applications (DCA)

Awards and Honors
Oracle PL/SQL Developer Certified Associate (OCA)
Oracle Database: SQL Certified Expert
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000

©2016 About.com. All rights reserved.