81. Inner connection inner join? Select a. * From bsempms a, bsdptms b where a.dpt_no = b.dpt_no; 82. How to connect? Select a. * From bsempms a, bsdptms b where a.dpt_no = B.DPT_NO ( ); Select a. * From bsempms a, bsdptms b wherea.dpt_no ( ) = b.dpt_no; 83. How to perform script SQL files? SQL> @ $ path / filename.sql; 84. How to quickly empty a big Table? SQL> Truncate Table Table_name; 85. How many database instances? SQL> Select * from V $ instance; 86. How to query the database how many tables? SQL> Select * from all_tables; 87. How to test SQL statements Time used? SQL> SET TIMING ON; SQL> Select * from TableName;
88. The anti-function of chr () is? ASCII () Select char (65) from Dual; select ASCII ('a') from Dual; 89. String SELECT Concat (Col1, Col2) from table; select col1 | COL2 from table; 90. How to guide the results from SELECT to a text file? SQL> Spool c: /abd.txt; sql> select * from table; sql> spool off; 91. How to estimate SQL execution I / O number? SQL> set autotrace on; SQL> Select * from table; or sql> Select * from V $ fileStat; you can view the number of IO
