FS_FILES_TREE
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| FILE_ID | NUMBER(38) | N | NO | NO | NO | |
| FILE_TITLE | VARCHAR2(500.0) | N | NO | NO | NO | |
| SORT_KEY | NUMBER(38) | N | NO | NO | NO | |
| DEPTH | NUMBER(38) | N | NO | NO | NO | |
| FOLDER_P | CHAR(1.0) | Y | NO | NO | NO | |
| OWNER_ID | NUMBER(38) | N | NO | NO | NO | |
| DELETED_P | CHAR(1.0) | Y | NO | NO | NO | |
| GROUP_ID | NUMBER(38) | Y | NO | NO | NO | |
| PUBLIC_P | CHAR(1.0) | Y | NO | NO | NO | |
| PARENT_ID | NUMBER(38) | Y | NO | NO | NO | |
| THE_LEVEL | NUMBER(38) | Y | NO | NO | NO | |
Query:
select
file_id,
file_title,
sort_key,
depth,
folder_p,
owner_id,
deleted_p,
group_id,
public_p,
parent_id,
level as the_level
from fs_files
connect by prior fs_files.file_id = parent_id
start with parent_id is null
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002