Correct understanding of XML in Oracle 11g

Is it a headache for you to correctly understand the actual XML operations in Oracle 11G? If this is the case, the following articles will give you corresponding solutions. The following articles mainly describe how to correctly understand the XML in Oracle 11g. The following describes the specific content.

As an independent Oracle Database consultant and a database technical website dedicated backup and recovery and database design expert, Brian Peasland has a full understanding of Oracleshen database. It took several days to help companies and individuals make full use of Oracle's flagship database management system.

For the latest version of Oracle 11g, we interviewed Peasland to learn about the planned Oracle changes and upgrades.

In this interview, Peasland discussed why he did not take advantage of the XML upgrades planned in Oracle 11g and talked about the fact that, that is, many of the users He talked about hoped that the next version of PL/SQL could include a better way to track PL/SQL call stacks. Peasland also provides some suggestions for those who are preparing to take the 10 Gb Oracle certification expert examination, as well as some keywords for Database beginners and veterans, and for those who want to get the Database 10 Gb correctly.

Oracle said the next version of its flagship Database management system, Oracle Database 11 GB, includes new XML upgrades. They focused on xml db and included a new XML binary data and a New XML index. Are these types of updates important? Why or why not?

Brian Peasland: For me, most of the XML content in the database is not very important, because XML is organized in hierarchical format, which was proved in 1980s, the layer-level format of data does not support fast and efficient data retrieval. I was confused when they started to apply the XML format to relational databases.

We cannot simply search for a little XML data in a table, and it is faster and easier than others. This usually means that you must split the data. I never like to put XML in a database, and I never need to do this. I do know that some people need to do this and it also makes sense for their special applications.

However, their storage of xmlis more like storing .wav files in the data warehouse. They do not store it as common data that can be queried in the future. They want to really store XML as a complete file, not a piece of data.

Why do the people you mentioned need to store XML as a complete file?

Peasland: for example, the new Microsoft Office version uses XML as its standard format. Replacing the Word-type capital file format used in the original database, maybe they want to store this new XML format as a document in the database. Although, they can run tools like Oracle Text to quickly search documents. But this is a way to try something that I have seen-they want to store comprehensive data, such as a list of employees, in XML format in the database-completely different from what I have seen. For me, the attributes and data rows that represent the project object should be stored in a relational table.

What changes do you want to make to PL/SQL in the Database management system of Database 11 GB or other Oracle versions?

Peasland: many people are asking about a simpler way to track PL/SQL call stacks these days. To be honest, I am not sure why, but I did meet someone who wants to do this. A guy can't help but want to track and store it. DBMS_DEBUG's bug tool has existed for a long time. With it, you can track your PL/SQL call stack, but it is very difficult to use. SQL developers have made efforts in this regard. But there are some such items in the database that are better.

What other PL/SQL changes do you want to see?

Peasland: One of the changes I have expected is that SQL Server can make some things very simple, but this is not the case in Oracle PL/SQL. In SQL Server, I can make a stored procedure so that it can just spit out the data, as if it was the query itself.

In Oracle, to accomplish this, you must use a special data type as your parameter and then query it. You must use a Ref cursor or something similar. This is a little troublesome, but it would be nice if you could. Other platforms allow you to do this, But Oracle does not.

What do you think about SQL Developer? compared with similar products?

Peasland: one of the reasons why I like SQL Developer is that I can make some quick queries in SQL Developer in the same way as in SQL Server. The capabilities of SQL Developer can explain some of my queries, but they will be left there for those instances that do not comment on them to call again, this is a good way to debug and run queries for different test targets-it is definitely not for product use, but a developer tool.

Your website includes some important documents to help people pass the Oracle 10g Oracle certification expert exam. What suggestions do you give to those who plan to pass the exam?

Peasland: one of the major things I want to tell you is: 1. Read the documents about new features, because almost everything about the exam is included in the document. This is very important. I also know that people are afraid of documents, but I like this method, because the answers to most of my questions (as the website expert of SearchOracle.com) are all from the documents to find the correct answers. Read the document because it can familiarize you with such things. Another thing is to practice what you learned, because when you practice, you will start to learn some new features of work.

Then, take the initiative to try to break something. Obviously, you want to do this on the testing system. This system is accessible only to you, but not to anyone else, because you don't want to disturb anyone else's work. When you try to break something, you will learn new features.

Your website also provides information about violation policies and 10 Gb security protection for Oracle. Is there any good way to ensure the normal startup of Oracle 10g?

Peasland: There is a policy against everyone. Even if you directly install Oracle Outside the machine, some supply packages can be open to the public, this means that everyone in the database can use them. The ability to use these packages may cause security vulnerabilities. For example, there is a package named UTL_File. It allows some people in the stored procedure to interact with the file system where the database is located.

You may not want to write files, because this may bring potential risks. Also, some famous Oracle experts have made it clear that things like UTL_File will let people probe databases. We have heard that such a security vulnerability always exists, and it is not unique to Oracle. Users in the database should have the minimum permissions, which means they should only have the minimum permissions required to complete the task. The above content describes how to understand the XML in Oracle 11g, hoping to help you in this aspect.