Oracle SQL-订单数据存储在数据库中 [英] Oracle SQL - Order data stored in a database

问题描述

我想知道是否有人知道是否有一种方法可以对数据库中已经存在的数据进行排序.也就是说，我想对其中的内容进行排序，但不要在查询中检索它.

I was wondering if anyone knows if there is a way to sort the data that already resides in a database. That is, I want to sort what is there but NOT retrieve it in in query.

我之所以问是因为我在数据库中有一个清单，希望以后再添加，并在添加它们后对其进行排序.

I am asking because I have a list of things in this database, that I would like to add to in future and would like to order it once I've added them.

所以我的意思是，我不想下载所有数据.把它分类;然后将其放回数据库中.

So what I mean is, I would like to not have to download all the data; sort it; then put it back onto the database.

谢谢.

推荐答案

我想知道是否有人知道是否有一种方法可以对数据库中已经存在的数据进行排序.

I was wondering if anyone knows if there is a way to sort the data that already resides in a database.

普通关系表，称为堆组织表，以任何顺序(即未排序)存储行.仅在获取时(而不是在存储时)对行进行排序.保证在检索行时进行排序的唯一方法是使用ORDER BY子句.

Normal relational tables, called as heap-organized tables, store rows in any order i.e. unsorted. You sort the rows if required only when you fetch them, not when you store them. And the only way to guarantee the sorting while retrieving the rows is to use an ORDER BY clause.

这篇关于Oracle SQL-订单数据存储在数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！