Oracle?????????????
???????????? ???????[ 2014/4/25 10:46:39 ] ????????oracle ????? ???????
????oracle??????????????sys?????system???
??????1??sys????????????????и?????????sysdba???????create database?????????????????????manager
??????2??system?????????????????????????sysoper????????create database????????????????change_on_install
??????3??????????????????????????system?????????ɡ?
????????????
??????1??????????
????conn ?????/???? [as sysdba / sysoper]
???????????????????????????????as sysdba ????as sysoper
??????2?????????
????disc ??????????????????????????
??????3?????????
????passw[ord]
?????????????????????????sys????system
????password scott; //??scott??????????
??????4?????????????
????show user;
??????5?????
????exit;???????????
???????????????
??????1?? start??@ ????sql???
????start d:aa.sql ???? @ d:aa.sql
??????2??edit d:aa.sql ??sql???
??????3??spool ??????????????????????
????spool d:aa.sql??
????select * from emp; //??????
????spool off;
??????????????????????
??????1??linesize ????????е???
????set linesize 50; //???80
??????2??pagesize ?????????????????????14
?????÷???linesize ???
????set pagesize 14;
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11