207 reputation
17
bio website student.eepis-its.edu/~asns17
location Surabaya, ID
age 25
visits member for 1 year, 5 months
seen Mar 21 at 15:55

Learning from Sharing


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?
Feb
22
asked Startup NOMOUNT and Startup MOUNT on dataguard oracle
Jan
8
awarded  Yearling
Dec
30
answered How to fix this error Idk?
Dec
30
answered why archived log size is small but fast recovery area still has a lot free space
Dec
5
answered How to make sqlplus output appear in one line?
Dec
5
answered distinguish single-block vs multi-block reads in Oracle explain plan
Dec
5
answered ORACLE error while dbstart command
Sep
20
revised Why do I have to select from the dual table?
added 22 characters in body
Sep
19
answered Dividing comma separated strings into columns
Sep
19
awarded  Commentator
Sep
19
comment retrieve data based on a condition
nice reply @SebastianMeine :)
Sep
19
revised Is Oracle free to download?
added 467 characters in body
Sep
19
answered Is Oracle free to download?
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
Jun
13
accepted Error Code : 1248 Every derived table must have its own alias in MySQL
Jun
13
answered Error Code : 1248 Every derived table must have its own alias in MySQL
Jun
13
asked Error Code : 1248 Every derived table must have its own alias in MySQL