The client_info table has four columns:
| Column | Description |
|---|---|
| client | Client's name |
| attr | Client's attributes |
| info | Information about the client |
| flags | Flag information about the client |
Note:
nispopulate does not populate this table.
| Column | Description |
|---|---|
| client | Client's name |
| attr | Client's attributes |
| info | Information about the client |
| flags | Flag information about the client |
SELECT fifst.STRUCTURE_VIEW_NAME, fifst.ID_FLEX_STRUCTURE_NAME, fifst.CONCATENATED_SEGMENT_DELIMITER, -- Разделитель сегментов fifs.application_column_name, fifs.segment_name, fifs.segment_num, ffs.flex_value_set_name, -- НЗ привязанный к сегменту ffs.description -- Описание НЗ FROM fnd_id_flex_structures_vl fifst, -- Информация о структуре КГП fnd_id_flex_segments fifs, -- Сегменты структуры fnd_flex_value_sets ffs -- Набор значений WHERE fifst.id_flex_structure_code = 'ACCOUNTING_FLEXFIELD' -- Код структуры "План счетов..." AND fifst.application_id = 101 -- Приложение: Главная книга AND fifst.id_flex_code = 'GL#' -- Название ГП: ГП Плана счетов AND fifs.application_id = fifst.application_id AND fifs.id_flex_code = fifst.id_flex_code AND fifs.id_flex_num = fifst.id_flex_num AND ffs.flex_value_set_id = fifs.flex_value_set_id order by fifs.segment_numSQL> create table test (value number(3)); Table created. SQL> insert into test values (1); 1 row created. SQL> insert into test values (3); 1 row created. SQL> insert into test values (2); 1 row created. SQL> select rownum, value from test order by value; ROWNUM VALUE ---------- ---------- 1 1 3 2 2 3
SQL> select * from test where rownum > 1; no rows selected
select o.* from (select rownum rw , o.* from (select o.* from all_tables o order by table_name) o where rownum < 20 ) o where o.rw >= 10;
select o.* from (select o.* , row_number() over (order by o.table_name) rw from all_tables o ) o where o.rw >= 10 and o.rw < 20;