232 reputation
110
bio website student.eepis-its.edu/~asns17
location Surabaya, ID
age 26
visits member for 1 year, 11 months
seen Sep 16 at 1:18

Learning from Sharing


Aug
25
comment ORACLE error while dbstart command
you can see at your user bash profile. or do export $ORACLE_HOME to correct oracle home location
Feb
27
comment Oracle Databases - need to export nightly for backup/DR purposes
nice Reply @Mixcoatl :)
Feb
24
comment Startup NOMOUNT and Startup MOUNT on dataguard oracle
are you sure there is no practical difference between these two?
Feb
22
comment Startup NOMOUNT and Startup MOUNT on dataguard oracle
yes i read it before. but whats relation with data guard environment?
Sep
19
comment retrieve data based on a condition
nice reply @SebastianMeine :)
Sep
19
comment Why do I have to select from the dual table?
@Lukasz Lech in Oracle there is no SELECT without FROM for #MSSQL Serv: There is no need of Dual table in SQL Server at all. but if you transferred your code from oracle to SQL Serv you can create dual using this script CREATE TABLE DUAL ( DUMMY VARCHAR(1) ) GO INSERT INTO DUAL (DUMMY) VALUES ('X') GO but, I don’t see any reason to use/create Dual table in sql server. and also MSSQL Serv and PostGRE SQL dont require Dummy table
May
7
comment Using a Having clause with an outer join
omg..... i forgot it. i see order by as group by, sorry mate, ur right. thanks for helping me T_T #feelsdizzy
Apr
26
comment Why do I have to select from the dual table?
you can create it using create table dual (dummy varchar2(1)) storage (initial 1) or flashback table dual to before drop
Apr
26
comment Why do I have to select from the dual table?
well if thats happen to you. revoke all privileges except for CREATE SESSION from this Someone person. and what if dual was dropped accidentally by someone?
Nov
23
comment How to see list of databases in Oracle?
"Is there an equivalent to MySQL SHOW DATABASES statement?" im trying to answers that question. dont say u dont know
Nov
12
comment Why do I have to select from the dual table?
Thanks Jack im still newbie here :D
Nov
7
comment MySQL - Create a function from another function
great Rolando. thanks for helping.