oracle查询语句大全（Oracle query Daquan）.docVIP

oracle查询语句大全（Oracle query Daquan） Oracle cannot use limit when paging queries, so thats all Select from table_name where rownumbegin and rownum end 2.sql = select * from table Con.prepareCall (SELECT * FROM (SELECT A.*, rownum R FROM ( +sql+ ) A WHERE rownum = +intPage*intPageSize+ ) B WHERE R (int1) + *intPageSize); Today, I would like to check all the table names under the Oracle database or all the tables under a user. I havent thought about it for a long time. I found the answer on the Internet Select table_name from all_tables; / / all that Select table_name from user_all_tables; / / all table users What is the post of SQL statement? Select from * user_objects; / / query all tables Select from * dba_tables; / / query all tables Select from * all_tables; / / query all tables Select * from user_users / / find a user Select * from all_users / / query for all users Select * from dba_users / / query for all users Select name, dbid from v$database; / / query the database name and its ID Select from * sys.user_tab_columns; / / query table name, column name and display Describe the name of the table / query table structure Select * from sys.user_tab_columns where table_name= / / query table name field specifies the table name 2: query database parameters Show parameter db; 3: query the database instance name Select instance_name from v$instance; 4: database domain name After the database is installed, if you want to know whether the database is running, the domain name and the domain name of the database can be used Select, value, from, v$parameter, where, name=db_domain Show parameter domain 5: database service name If the database has a domain name, the database service name is the global database name. If the database does not define the domain name, the database service name is the same as the database name Show parameter service_name 6: displays the current user Show user 7: direct landing Sqlplus /as SYSDBA 8: current ORACLE system time Select sysdate from dual