0

Tables grouped into two sections

Using SQL Plus, I create 13 tables via an .sql file, each containing primary and foreign keys. When I execute "select table_name from user_tables;" they are displayed in this partitioned fashion. The number of tables in each partition varies each time the tables are dropped then recreated. Each table is unique/there are no repeating tables.

I am having difficulties interfacing with the DB via php/OCI (I can access the column headings, but no records are found) and was wondering if this could be the reason. This is after multiple INSERTs, and SQL PLUS queries confirm the existence of records.

Overall, what does this grouping mean, is it problematic and how can I resolve the tables into one grouping?

  • Perhaps this is some paging setting of the interface you use for connecting to the database? – ypercubeᵀᴹ Apr 29 '16 at 11:57
0

That is just the paging in SQL*Plus. By default the paging value is 14, that includes a blank line at the start of each page, the line with column headers, the line with heading separators (hyphens) and the rest (11 rows) is for user data.

If you increase the pagesize, the result of your query will fit in to 1 page:

set pagesize 20

It has nothing to do with php/OCI.

SET PAGES[IZE] {14 | n}

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.