I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?

I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?
by

1 Answer

Answer :

answer:PL\SQL really isn’t my thing, but I believe you need something between the first IF statement and the ELSIF. What do you want it to do with the number if it is 50 or 90?
by

Related questions

Does anyone here have experience working with PL/SQL? I need some help getting started...

Description : Does anyone here have experience working with PL/SQL? I need some help getting started...

Last Answer : answer:PL/SQL is Oracle's take on SQL. It's mostly vanilla SQL, but with some Oracle-specific twists. You need Oracle SQL Developer or something similar. I doubt other relational ... more closely resembling a true object-oriented language, so make sure you get something Oracle-specific!.

What are three panes that appear in the run time pl/sql interpreter?

Description : What are three panes that appear in the run time pl/sql interpreter?

Last Answer : 1. Source pane. 2. interpreter pane. 3. Navigator pane.

You have just compiled a PL/SQL package but got errors, how would you view the errors?

Description : You have just compiled a PL/SQL package but got errors, how would you view the errors?

Last Answer : SHOW ERRORS

What is better: One big SQL query or several?

Description : What is better: One big SQL query or several?

Last Answer : It’s difficult without examples. But what you describe seems like a simple join.

Where can I learn quickly the differences between using SQL Server 2008 and Toad for Oracle?

Description : Where can I learn quickly the differences between using SQL Server 2008 and Toad for Oracle?

Last Answer : answer:The SQL code IS different. Oracle and SQL Server syntax can differ from the ANSI version of SQL. For example, when you write a JOIN in SQL, you MUST use the OUTER JOIN ON syntax, where ... can also use the Query Builder to write queries for you by dragging and dropping - just like Access.

How to solve this problem I have with a restore (backup) file I made in SQL Server 2008?

Description : How to solve this problem I have with a restore (backup) file I made in SQL Server 2008?

Last Answer : try to see if you have volume optimization enabled, it prevents certain changes from happening and really gives the user a hell of alot more trouble than it is worth.

When to use stored procedure and when function in SQL Server 2008?

Description : When to use stored procedure and when function in SQL Server 2008?

Last Answer : There’s no technically right answer here – I think I’d do the SP calling SP.

What is the basic structure of PL/SQL ?

Description : What is the basic structure of PL/SQL ?

Last Answer : PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.

What are the datatypes a available in PL/SQL ?

Description : What are the datatypes a available in PL/SQL ?

Last Answer : Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN. Some composite data types such as RECORD & TABLE.

What command would you use to encrypt a PL/SQL application?

Description : What command would you use to encrypt a PL/SQL application?

Last Answer : WRAP

How you were passing cursor variables in PL/SQL 2.2?

Description : How you were passing cursor variables in PL/SQL 2.2?

Last Answer : In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with version 2.2, the only means of passing a cursor variable to a PL/SQL block is via bind variable or a procedure parameter.

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Description : Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Last Answer : No, a cursor variable points a row which cannot be stored in a two- dimensional PL/SQL table.

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

What are the cursor attributes used in PL/SQL ?

Description : What are the cursor attributes used in PL/SQL ?

Last Answer : %ISOPEN - to check whether cursor is open or not % ROWCOUNT - number of rows fetched/updated/deleted. % FOUND - to check whether cursor has fetched any row. True if rows are ... featched. These attributes are proceeded with SQL for Implicit Cursors and with Cursor name for Explicit Cursors.

What are the components of a PL/SQL block ?

Description : What are the components of a PL/SQL block ?

Last Answer : A set of related declarations and procedural statements is called block.

What are the components of a PL/SQL Block ?

Description : What are the components of a PL/SQL Block ?

Last Answer : Declarative part, Executable part and Exception part.Datatypes PL/SQL

What are the PL/SQL Statements used in cursor processing ?

Description : What are the PL/SQL Statements used in cursor processing ?

Last Answer : DECLARE CURSOR cursor name, OPEN cursor name, FETCH cursor name INTO or Record types, CLOSE cursor name.

Explain how procedures and functions are called in a PL/SQL block ?

Description : Explain how procedures and functions are called in a PL/SQL block ?

Last Answer : Function is called as part of an expression. sal := calculate_sal ('a822'); procedure is called as a PL/SQL statement calculate_bonus ('A822');

Question What is PL/SQL ?

Description : Question What is PL/SQL ?

Last Answer : PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching.

What are the two panes that Appear in the design time pl/sql interpreter?

Description : What are the two panes that Appear in the design time pl/sql interpreter?

Last Answer : 1. Source pane. 2. Interpreter pane

Where is a procedure return in an external pl/sql library executed at the client or at the server?

Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?

Last Answer : At the client.

Python has a SQL-like querylanguage called ________- a) GQL b) PL SQL c) NOSQL d) JDBC

Description : Python has a SQL-like querylanguage called ________- a) GQLb) PL SQL c) NOSQL d) JDBC

Last Answer : GQL

What is the significance of the & and && operators in PL SQL ?

Description : What is the significance of the & and && operators in PL SQL ?

Last Answer : The & operator means that the PL SQL block requires user input for a variable. The && operator means that the value of this variable should be the same as inputted by the user previously ... span across different rollback segments or will it terminate ? It will terminate (Please check ).

Can you have two functions with the same name in a PL/SQL block

Description : Can you have two functions with the same name in a PL/SQL block

Last Answer : Yes.

Does PL/SQL support “overloading”? Explain

Description : Does PL/SQL support “overloading”? Explain

Last Answer : The concept of overloading in PL/SQL relates to the idea that you can define procedures and functions with the same name. PL/SQL does not look only at the referenced name, however, ... Prefacing a procedure or function name with the package name fully qualifies any procedure or function reference.

Identify the DBMS among the following. (1) MS-Access (2) MS-Power Point (3) PL/SQL (4) MS-Excel

Description : Identify the DBMS among the following. (1) MS-Access (2) MS-Power Point (3) PL/SQL (4) MS-Excel

Last Answer : PL/SQL

What is the HTML code of Visit Count below Needsbd.wapkiz.com ?

Description : What is the HTML code of Visit Count below Needsbd.wapkiz.com ?

Last Answer : You can find http://redowan.wapkiz.com on this website.

Anybody know how I can integrate .zip files with PHP?

Description : Anybody know how I can integrate .zip files with PHP?

Last Answer : http://www.net2ftp.com/ allows you to do this. You could dig through the source (you can download it there) and figure out how they did it. Or you could just install net2ftp and have them use that instead.

How can a computer understand human language ?

Description : How can a computer understand human language ?

Last Answer : Computer can understand human language when it is converted to mechanical language.

Why won't xcode recognize these variables?

Description : Why won't xcode recognize these variables?

Last Answer : i wish i could help, but all i can really offer is a shot in the dark based off other lesser languages i know. i only see one instance of ' exampleofcharacter'' so my total uneducated guess, ... that does not exist. other than that i cant say anything, not familiar with this language at all.

Define what is the difference between compile-time polymorphism and run-time polymorphism?

Description : Define what is the difference between compile-time polymorphism and run-time polymorphism?

Last Answer : Compile time Polymorphism Compile time Polymorphism also known as method overloading. Method overloading means having two or more methods with the same name but with different signatures. Run time ... or more methods with the same name, same signature but with a different implementation.

What error will be generated if a space is given between the logical AND operator (&&)? Will it be a compile-time or a run-time error?

Description : What error will be generated if a space is given between the logical AND operator (&&)? Will it be a compile-time or a run-time error?

Last Answer : Example: if(5>2 & & 6

Differentiate between run time and compile time polymorphism.

Description : Differentiate between run time and compile time polymorphism.

Last Answer : Sr. No. Compile time polymorphism Runtime polymorphism 1 In this polymorphism, an object is bound to its function call at compile time. In this polymorphism, ... is implemented with operator overloading or function overloading It is implemented with virtual function.

Compare run-time and compile-time polymorphism.

Description : Compare run-time and compile-time polymorphism.

Last Answer : Compare run-time and compile-time polymorphism.

Write any four differences between compile time and run time polymorphism.

Description : Write any four differences between compile time and run time polymorphism.

Last Answer : Sr. No. Compile-time Polymorphism Run-time Polymorphism 1 Compile time polymorphism means that an object is bound to its function call at compile time. Run time polymorphism means that selection ... binding. 7 E.g. overloaded function call. E.g. virtual function.

What does Java run, operate, or do?

Description : What does Java run, operate, or do?

Last Answer : answer:This is a bit complicated, but I'll do my best to explain. At a fundamental level a computer program is simply a series of instructions the CPU in your computer executes in sequence. Programming languages ... wait. It's an inherently slower process to do on the fly. Hope that helps a bit.

How do I get pythonw run in the background in a .cmd file?

Description : How do I get pythonw run in the background in a .cmd file?

Last Answer : answer:Use a vbs file to run it invisibly, but you won’t be able to se it in task manager either. Should work with .cmd or anything else really. Set WshShell = CreateObject(“WScript.Shell”) WshShell.Run chr(34) & “yourbatchfile.bat” & Chr(34), 0 Set WshShell = Nothing

Can the human brain run software unaided?

Description : Can the human brain run software unaided?

Last Answer : answer:Not unaided, no. I mean… you’d need a USB port or a CD-drive to get it in there. You can’t “install” software into your brain. Running software in your mind would just be using your imagination and/or logic and reasoning.

How do I simply repeat a line of code 4x in Javascript?

Description : How do I simply repeat a line of code 4x in Javascript?

Last Answer : something like a for loop is pretty simple, and gives you a handy counter if needed. for(var i = 0; i < 4; i++) { forward(); }

Programmers: Thoughts on this AI game where you fight via code?

Description : Programmers: Thoughts on this AI game where you fight via code?

Last Answer : answer:Hmm. Cool, but so far I’m stuck on the tutorial with some sort of error: > Game.mothership.moveTo(1,0) undefined

Do you still use spaghetti code , like QBasic?

Description : Do you still use spaghetti code , like QBasic?

Last Answer : talljasperman Sorry I didn’t know that spaghetti code was a pejorative. My teacher called it that and I did not look it up.

How can I swap two integers without temporary variables using JavaScript code?

Description : How can I swap two integers without temporary variables using JavaScript code?

Last Answer : answer:This is a trick using the exclusive or operator ^ that was used when computers were short on memory. a = (a ^ b) /* a^b, b */ b = (a ^ b) /* a^b, a */ a = (a ^ b) /* b, a */ You can also do it using subtraction for numeric ... = a - b /* a - b, b */ b = b -a /* a-b, a */ a = b - a /* b, a */

What does this short snippet of C code do? (see details)

Description : What does this short snippet of C code do? (see details)

Last Answer : answer:It's been a long time since I did much in C but It looks like it reads a file (or url?) and assigns that reference to the variable handle to use later, then reads each ... meant to return file contents in an expected format for use elsewhere. More of the context would provide more clues.

How does computer code break?

Description : How does computer code break?

Last Answer : Errors in logic, programming errors with the language used; type of programming involved eg. application prgm, operating system executable, etc . operating system upgrades can be any number of items ... is alway helpful when fixing programming problems.. Albeit,a general answer, I hope it helps

How to implement a JavaScript code that doing "Set as my Home Page" in Google Chrome?

Description : How to implement a JavaScript code that doing "Set as my Home Page" in Google Chrome?

Last Answer : So, you’re saying the JavaScript code for doing this works in IE and Firefox, but not Chrome? That’s weird. Let me see if I can find a script for you.

Would appreciate tips on reading someone else's code and understanding it .

Description : Would appreciate tips on reading someone else's code and understanding it .

Last Answer : First hint: if there are no coments smack the someone else in the face with a crowbar. That said there's really not much to say, you should be able to figure out what the code says ... trying to understand what the subroutines are for and then from that wrking out why the bigger parts need them.

Python Code error?

Description : Python Code error?

Last Answer : You have too many parens in that line—you’re passing in a tuple instead of two integers.

Do I have to give up my source code to a .NET DLL I wrote?

Description : Do I have to give up my source code to a .NET DLL I wrote?

Last Answer : It depends on the contract that you had with the client. You might want to check Free Lance Switch. It’s a community of Freelance designers/coders. They might be able to help you out more.

Is there somewhere where I can have someone look at my code and give me suggestions on how to make it better?

Description : Is there somewhere where I can have someone look at my code and give me suggestions on how to make it better?

Last Answer : There are dozens of PHP forums on the web where you can submit things like that. Just search for PHP community or PHP forum. Most web design forums and communities will have an area for programming ... own forums as well. Just post a thread showing your code and asking for whatever help you need.

The OpenGL source code for an open source Breakout game?

Description : The OpenGL source code for an open source Breakout game?

Last Answer : Here is one Learning and copying from others code is cool. Using code is cool if credits are made.