111. Return to the minimum value equal to Is N? SELECT CEIL (N) from Dual; 112. Returns the minimum integer value of equal to N? SELECT FLOOR (N) from Dual; 113. Return to the last day of the current month? SELECT LAST_DAY Sysdate) from Dual; 114. How to Data Imports between Different User Data? IMP System / Manager File = aa.dmp fromuser = User_old Touser = User_New Rows = Y Idexes = Y;
115. How to find the name of the primary key field of the database table? SQL> Select * from user_constraints where constraint_type = 'p' and table_name = 'table_name'; 116. Two result sets Mutual function? SQL> Select * from bsempms_old intert Select SELECT * FROM BSEMPMS_NEW; SQL> SELECT * FROM BSEMPMS_OLD UNION SELECT * FROM BSEMPMS_NEW; SQL> SELECT * FROM BSEMPMS_OLD UNION ALL SELECT * FROM BSEMPMS_NEW;? 117. Save two result sets mutual function SQL> SELECT * FROM BSEMPMS_OLD mINUS SELECT * FROM BSEMPMS_NEW; 118. how to configure Sequence build sequence seq_custid create sequence seq_custid start 1 incrememt by 1; when built table:? create table cust {cust_id smallint not null, ...} insert when: insert into table cust values (seq_cust.nextval, ...) 119>. Common written method for each part of the date: select to_char (sysdate, 'yyyy') from dual; 120>. Write the time point of the month: select to_char Sysdate, 'mm') from dual;
