Oracle

61. How to view which of the following statements are available in Oracle?ProgramRunning? View the V $ sessions table 62. How can I see the number of tablespaces in the database? Select * From dba_tablespaces; 63. How do I modify the number

81. Inner join? Select a. * From bsempms A, bsdptms B where a. dpt_no = B. dpt_no; 82. How do I connect externally? Select a. * From bsempms A, bsdptms B where a. dpt_no = B. dpt_no (+ ); Select a. * From bsempms A, bsdptms B wherea. dpt_no (

101. How to search for the first N records? Select * from employee where rownum Order by empno; 102. How many concurrent users are supported by Oracle on the machine? SQL> conn internal;SQL> show parameter processes; 103. Can db_block_size be

I encountered a problem today: I forgot the password of the internal account: (I checked the information and found a way to enter the database: In the Oracle database system, if you want to log on to the Oracle database as a privileged user

Method 1) Add the following script to/etc/rc. d/rc. Local or/etc/rc. d/RC # Setting Environment VariablesExport oracle_base =/opt/OracleExport ORACLE_HOME =/opt/Oracle/product/9204Export Path = $ ORACLE_HOME/bin: $ ORACLE_HOME/Apache/bin: $

41. How do I add comments to tables and columns? SQL> comment on table is 'table annotation'; the comment has been created. SQL> comment on column table. The column is 'column annotation'; the comment has been created. SQL> select * From

71. Kernel Parameter application? Shmmax　　Meaning: This setting does not determine the actual amount of physical memory used by the Oracle database or operating system. It only determines the maximum amount of memory that can be used. This setting

91. How to estimate the number of I/O executed by SQL? SQL> set autotrace on; SQL> select * from table; Or SQL> select * from V $ filestat; I/O count can be viewed 92. How can I change the field size in sqlplus? Alter table table_name modify

121>. Write the date at the time point: Select to_char (sysdate, 'dd') from dual; 122>. Write the time point: Select to_char (sysdate, 'hh24') from dual; 123>. Write the time points: Select to_char (sysdate, 'mi') from dual; 124>. The second

MySQL large object access: The mediumblod type is generally used, Blob can only store 16 bytes to the power of 2, Mediumblod is the power of 24, Generally enough. longblob is a bit large to the power of 32. By default, MySQL can only store files of

Note: When you load a class into the database, you cannot execute the class in the sqlplus command line. The class name should not start with the package name. Otherwise, the class cannot be found or the package name should be specified during the

0. Create an environment SQL> create usertest identified by test 2 default tablespace users 3 temporary tablespace temp 4 quota unlimited on users;User created.SQL> grant createsession, resource, alter session to test;Grant succeeded.SQL>

Oracle interview questions-Technical Article (2) 21. How to determine the time zone of the database?Answer: Select dbtimezone from dual; 22. Explains the purpose of setting global_names to true.A: global_names indicates how to connect to the

Release date: Source: collected: -- Insert bfile create or replace procedure insert_book (filename varchar2)Book_file bfile: = NULL;Bookexists Boolean: = false;BeginBook_file: = bfilename ('book _ text', filename );Bookexists: = dbms_

This article discusses how to use ADO. Net to access Oracle stored procedures (called SQL programming blocks) and functions (return a single value of the programming block ). You can use the following managed data providers to connect to the Oracle

Source: Network/Editor: getting started with programming: Unknown The crystal report version is 8.5 The stored procedure is: create or replace package pkg_test4astype v_cursor is ref cursor;end pkg_test4;/create or replace procedure

Source: Network/Editor: getting started with programming: Unknown 　　 　　　　'-----------------------------------Dim sp_commonSet sp_common = server. Createobject ("ADODB. Command ")With sp_common. Activeconnection = Conn. Commandtext = "

1. Clob Insert Field Direct insert of clob data may cause errors due to long characters. Therefore, you must insert data as an object. Example: First, create a table containing the clob field: Create Table Test (ID integer, content clob );  

Download source code: Http://download.csdn.net/source/589896     Use oradbi to read multiple files stored in the Blob field and restore them to the specified path. The complete code is as follows:   // // Read_blobfile.c-Example of reading

How to Create a tablespace? Create tablespace test logging datafile 'd: \ oracle \ oradata \ orcl \ test. ora 'size 50 m autoextend on next 50 m maxsize unlimited extent management local; How to create a user? Create User Username profile default