Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Oracle SQL Plus The Definitive Guide- P61:Every day, computer professionals the world over wake up, travel to the office, sit down in front of a computer, and begin another day working with that database called Oracle. Programmers write queries and stored procedures. Database administrators monitor performance, make database changes, and perform other maintenance tasks. Operations people may need to back up or recover a database. | previous page page_501 next page Page 501 USER views 181-182 USER_TABLES view 194 Users connecting as other 30-32 442 logging in as administrator 326-330 product user profile 23 309-325 creating profile table 316-318 disabling commands access 318-320 disabling roles access 320-321 limitations 313-316 reporting on 322-325 prompting for values 124-137 display text for 135-137 extract scripts 165 session-duration definitions 128-132 TERMOUT setting and 127 132 tables owned by listing 194 USING BACKUP CONTROLFILE clause RECOVER 452 UTLXPLAN.SQL script 284 V. V V_ pseudoviews see dynamic performance views V7 V8 parameters SET COMPATIBILITY 408 VALIDATED column ALL_CONSTRAINTS 187 validating user input 262 ACCEPT statement 263-267 SQL for 267-269 values prompting users for 124-137 session-duration definitions 128-132 TERMOUT setting and 127 132 VARCHAR2 datatype 199 229 467 VAR IABLE command 229 467 Variable Size value SGA 337 variables bind variables 228-243 declaring 229 467 displaying contents of 233-238 how to use 238-243 printing contents automatically 386 substitution variables with 230-233 prompting users for values 124-137 display text for 135-137 extract scripts 165 session-duration definitions 128-132 TERMOUT setting and 127 132 resetting definitions 131 146 SQL Plus system variables 78 substitution user variables bind variables with 230-233 changing prefix character 151 defining 128-132 144-146 443 disabling 150 examining listing 145 extract scripts 165 reports 93-94 scripts 123-132 settings for 410-413 troubleshooting 146-151 verification 137 within comments 153 VAR IANCE parameter COMPUTE command 98 441 V DATAFILE view 342 verification turning off 137 394 VER IFY setting 137 394 version of Oracle specifying 407 versions of SQL Plus xviii command-line vs. GUI 18 displayed at startup 22 25 VIEW operation EXPLAIN PLAN 292 views data dictionary 180-193 definitions of viewing 176 dynamic performance views 293 VIS IBLE parameter SET SHIFTINOUT 380 V LOGFILE view
