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

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

1 Answer

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 databases can handle the specific differences that turn SQL into something more closely resembling a true object-oriented language, so make sure you get something Oracle-specific!.
by

Related questions

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?

Description : 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?

Last 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?

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.

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 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

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.

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

Do you have experience with Microsoft XNA, what are its limitations? Working on a MMORPG game concept that requires a dynamic map and environment.

Description : Do you have experience with Microsoft XNA, what are its limitations? Working on a MMORPG game concept that requires a dynamic map and environment.

Last Answer : I don't have any personal experience with XNA (I'm not really into game development) but a lot of the other computer science majors I know are doing a concentration in game development and ... , at least more positive feedback than can be said about lots of other common game development frameworks.

Telerik ASP.NET RadControls, anyone have experience styling these things?

Description : Telerik ASP.NET RadControls, anyone have experience styling these things?

Last Answer : Telerik has a tool, called Visual Style Builder, which will help you style their ASP.NET controls: http://www.telerik.com/products/aspnet-ajax/visual-style-builder.aspx The tool can be run ... check the documentation for instructions: http://www.telerik.com/help/aspnet-ajax/ajxajax.html Good luck!

Help with an error I am getting in VBA?

Description : Help with an error I am getting in VBA?

Last Answer : You might not have used selection with proper object. You can check it out in object browser (View->Object Browser) if the object you've used has that property/method or not. For example, if you are trying to ... block, make sure you end it with End With . Example: With Cells(1,1) .Value=1 End With

Working out top rated items?

Description : Working out top rated items?

Last Answer : When it comes to programming quandaries like this, I often go back to paper. Rip up a piece of paper and write some demo ratings on it for 5 products, including the database fields and their ... one approach to how your problem could be solved, likely not the most efficient, but it should work.

Anyone here have experience with purchasing a central air system for their house? If so, I need some advice about getting quotes, etc.

Description : Anyone here have experience with purchasing a central air system for their house? If so, I need some advice about getting quotes, etc.

Last Answer : I have a two story house (in North Carolina), each floor has it's own A/C system, the main floor has ducting underneath the floor and the second floor has ducting over the ceiling, the upstairs connects ... and shut off sooner and less air is cleaned by filters. You can have too much A/C tonnage!

Can anyone help me with some CSS?

Description : Can anyone help me with some CSS?

Last Answer : How is it jumbled? Often for IE i use a second stylesheet and apply it using : < ![endif]—> The first one is your first stylesheet, the second is a stylesheet that only fixes the things that are bad in IE.

I need to utilize a "Social Networking" bolt on solution...

Description : I need to utilize a "Social Networking" bolt on solution...

Last Answer : answer:You would go to an SEO marketing group. this San Diego based group does a fine job. They are called SEO HAUS. They are going forward and passing up SEO into the next generation of ... Twitter, Tumblr, YouTube Account etc and have you firing on all cylinders in a subtle and consistent manner!

If I downloaded a video, what format does it need to be in so it can open in ITUNES?

Description : If I downloaded a video, what format does it need to be in so it can open in ITUNES?

Last Answer : MP4

What languages do I need to know to create an online 2D shooting game?

Description : What languages do I need to know to create an online 2D shooting game?

Last Answer : Actionscript.

I need C troubleshooting: When i include a library do i have to do something more in order to have its functions work in my script?

Description : I need C troubleshooting: When i include a library do i have to do something more in order to have its functions work in my script?

Last Answer : Are you getting any other errors, like “math.h” not found? Actually, IIRC, not finding an include is just a warning…

What programming knowledge do I need to create web2.0 apps?

Description : What programming knowledge do I need to create web2.0 apps?

Last Answer : You don’t need Java necessarily which would be very advanced. HTML and CSS aren’t programming languages. To call something an application you need some kind of business logic. Javascript is an easy way to get started. You could also try PHP or Perl.

How do I create a website ? What do I need to know to create a website ?

Description : How do I create a website ? What do I need to know to create a website ?

Last Answer : See, creating a site is not an easy task. To create a site you need to know a lot of things like: HTML work , CSS , PHP , CEO JavaScript , Creative Knowledge and web development, etc. So you can ... you do not have to create a site to manage the site, you need to have some knowledge of the above.

Can you help me find some useful Wordpress plugins?

Description : Can you help me find some useful Wordpress plugins?

Last Answer : just to be sure you’ve checked wordpress plugins page right? you want each post to turn like a page? i think you would need to make that specially with either flash or ajax or something.

Can you help fix this programming problem in Python?

Description : Can you help fix this programming problem in Python?

Last Answer : You can’t treat arrays of digits as a single number. The easiest way to read a numeric string is to use the sys library to read a line from the keyboard. import sys print(“Enter value for mass”) mass = sys.stdin.readline() mass = float(mass)

Programmers: Is this puzzle a "named problem?" and can you help me with it?

Description : Programmers: Is this puzzle a "named problem?" and can you help me with it?

Last Answer : I'd call it enumerating a list of all combinations . There's a field of math called combinatorics which I did not study but I assume probably has a word for this. It doesn't seem like a puzzle ... each iteration, and tweak it to get the output format you want, but that's essentially it, I think.

Geometry Gurus. Can you help me solve for an angle?

Description : Geometry Gurus. Can you help me solve for an angle?

Last Answer : answer:The simplest solution would indeed be to have an IF ELSE statement there and have two separate cases depending on whether (RadialPointY - CenterPointY) is positive (@Angle < 180) or ... values it actually is cannot be determined without some sort of test of (RadialPointY - CenterPointY).

Any programmers willing to help me solve a triangle?

Description : Any programmers willing to help me solve a triangle?

Last Answer : Are you sure whether your language is using degrees vs. radians for the angle?

Any Python programmers willing to help me find a bug?

Description : Any Python programmers willing to help me find a bug?

Last Answer : Anything for the sake of science. I will look at the code and see if I can find the bug. As I understand it, you want to find the number of distinct locus values. By just looking at the csv ... just how the parsing is supposed to work. Also, what is the calling sequence to get the program started?

MySQL help!

Description : MySQL help!

Last Answer : answer:You spelled “propeller” wrong, for one thing. Table SERVICE_REQUEST has a primary key, SERVICE_ID, which is a DECIMAL field. In your attempt to load the table with the error record, the secondary key value you attempted to insert for SERVICE_ID, ‘7’ is a CHAR value. That’s a show-stopper.

Hey mathematicians, would you like to help me find patterns between rolling ball clocks?

Description : Hey mathematicians, would you like to help me find patterns between rolling ball clocks?

Last Answer : answer:I read the article & watched the video, but I don't get it. It takes 27 balls to display 12:59 (12 balls on the hours rack, 11 on the 5-min, 4 on the 1-min). But ... there are no simple rules among the numbers you've compiled. In other words, your algorithm might be its shortest description!

Can you help me find an App that can help one make App's? (any platform, including pen and paper, details inside)

Description : Can you help me find an App that can help one make App's? (any platform, including pen and paper, details inside)

Last Answer : answer:I'm not sure if it's quite what you're looking for, but my buddy makes AppCooker. You can use it with AppTaster to create mockups and make them play. I can't speak to their efficacy personally because ... charge $75-125/hour. If that's the route you end up wanting to take, feel free to PM me.

Excel spreadsheet help (formulas)

Description : Excel spreadsheet help (formulas)

Last Answer : Which version of excel are you using? In 2010 it has a square root function which is =sqrt(CellNameHere). Also as far as the second problem with the multiplication table can you not just use the cell name for example =$B$1*A2 and then drag it down?

Can somebody help me finding e-books to download for programming for MIT, Oxford, Harvard etc?

Description : Can somebody help me finding e-books to download for programming for MIT, Oxford, Harvard etc?

Last Answer : answer:“MIT OpenCourseWare makes the course materials that are used in the teaching of almost all MIT’s undergraduate and graduate subjects available on the Web, free of charge” http://web.mit.edu/ocw/

How to use cron in ruby on rails (2.3.5). Please help?

Description : How to use cron in ruby on rails (2.3.5). Please help?

Last Answer : answer:At the UNIX prompt, type man crontab and help documentation will appear. - Crontab is the interface you use to schedule jobs in cron. It launches a basic text editor - usually vi but anything you want - and you enter in one ... . 30 21 * * 3 /path/to/maintenance.sh # #---------------------