|
26
|
Oracle
|
Oracle LIMIT
|
 select o.* from (select rownum RWID , o.* from
|
0
|
|
23
|
Oracle
|
Data Pump in oracle 10g
|
# Create virtual directory
CREATE DIRECTORY D
|
0
|
|
22
|
Oracle
|
show user session
|
select sid,
to_char(logon_time,'MMDDYY
|
0
|
|
21
|
Oracle
|
crontab export Backup script
|
#!/bin/csh -f
#
#
# CRONTAB
# ORACLE BA
|
0
|
|
12
|
Oracle
|
Calculate LONG type size
|
declare
v_longest integer := 0;
begin
for
|
1
|
|
10
|
Oracle
|
Create tablespace
|
CREATE TABLESPACE "tableSpaceName" DATAFILE '/
|
2
|
|
11
|
Oracle
|
Create user
|
CREATE USER "userName" IDENTIFIED BY "userPass
|
0
|
