An SQL /PLSQL related question.?

An SQL /PLSQL related question.? Topic: An SQL /PLSQL related question.?
June 18, 2019 / By Andri
Question: From my theoretical study I read that SQL is the language used by the DBMS to manipulate the database, and PLSQL is the extension of SQL for Oracle databases.Now please answer the following confusion 1)If we write application programs that use the database (in this case Oracle), then do we use SQL/PLSQL commands in the code for our program? If so, then it's afterall the application programs that are using SQL, why then we say "SQL is used by the DBMS to manipulate database"? 2)I installed Oracle 10g enterprise edition and I can easily create tables and stuff from the GUI window or Oracle 10g. If I am to write an application program that uses this Oracle database on my computer, how do I go about it?Can I do this at all or I have to use the Oracle GUI interface only? Please bear with my naivete. I just finished a UG book on the topic and have no practical idea.
Advertisement
Best Answer

Best Answers: An SQL /PLSQL related question.?

Whitaker Whitaker | 10 days ago
1) SQL is the language that directly interacts with the database and the objects within it. PL/SQL is a scripting language that can embed SQL within it but also can make use of traditional procedural elements (loops, if/else, flat-file I/O, etc.) to carry out more complex algorithms. 2) If you have a PL/SQL script, you can invoke it to carry out a series of programmed tasks including forms for end-user input and reports for output. The standard GUI interface is more for the use of a developer than an end-user.
👍 128 | 👎 10
Did you like the answer? An SQL /PLSQL related question.? Share with your friends
Whitaker Originally Answered: i need help making a sorta friend related question?
First off, you should not be copying each other. Plagiarism is not allowed and if you get caught you can get into serious trouble. Secondly, yes it's a concern that he will start to take advantage of you. I would advise him that he can print off his work at the library or kinkos, just as a helpful tip. Say it nicely though, not in a rude way. Let him know that you don't want to copy work anymore, and just do your own work and have others edit it for you if you need help to make it better. Blessings to you =)
Whitaker Originally Answered: i need help making a sorta friend related question?
Depends on what it is, is it supposed to be his research if it is then tell him u will print it this time but next time u wont , u cpoied his essay and now ur printing stuff out, time to call it quits!

Samuel Samuel
1.) You want to make your SQL as standard as possible just incase you move to a new database. If you know you'll never move your database or only rarely, then use PLSQL to optimize your SQL. The application sends SQL to the DBMS. 2.) Applications use an API to access the DBMS. You can use JDBC is you're working with Java. If you're on Windows, you can use ODBC. I'm sure Oracle has libraries in a variety of languages that you import into your project to access the DB.
👍 40 | 👎 3

Nahum Nahum
ORDER with the help of is thoroughly pointless...all that does is reorder the resultset. team with the help of is likewise no longer required, altho that's normally utilized alongside side SUM. even nonetheless, you need to use the two or the two devoid of grouping...it only performs the computation on all rows that fulfill any the place standards. on your particular occasion, the question you wrote would not provide you what you prefer (and could desire to no longer paintings in any respect.) What you prefer is a team with the help of with HAVING standards (Having is to teams what the place is to guy or woman rows): go with Bno, count quantity(*) AS "# of team", SUM(salary) AS "entire salary" FROM team team with the help of Bno HAVING count quantity(*) > a million
👍 31 | 👎 -4

Nahum Originally Answered: how is checkers related to math?
Everything in the world is related to math in one way or another. For example, logic and strategy, both needed in checkers, are related to math. Planning is related to math. The shape of the board and the playing pieces are related to geometry. Consider the different openings that you could use in playing the game - there are statistics related to each opening play on the chances of winning the game with that opening. There are all kinds of other statistics involved such as the chances of getting pieces across the board and getting kings, the chances of winning with a certain number of pieces (probability), etc. The number of squares on the board can be connected to math. Anything in this world that you can mention is related to math. You just have to look for it.
Advertisement

If you have your own answer to the question An SQL /PLSQL related question.?, then you can write your own version, using the form below for an extended answer.