PL/SQL personal learning notes (2) and plsql personal learning notes

PL/SQL personal learning notes (2) and plsql personal learning notes

IF condition

Declare

Cursor s is
Select version from city_server t;
S _ city_server.version % type;
Begin
Open s;
Fetch s into s _;
If s _> 2
Then
DBMS_OUTPUT.put_line (s _);
End if;
Close s;

End;

LOOP

Declare
Cursor s is
Select version from city_server t;
S _ city_server.version % type;
Begin
Open s;
Loop
Fetch s into s _;
Exit when s % notfound;
DBMS_OUTPUT.put_line (s _);
End loop;
Close s;
End;

Plsql Study Notes 2

There are many brands of laptops, but from the recent computer warranty and after-sales service, the most important thing is the cost effectiveness, I recommend two brands of computers "Lenovo and HP"
Below I will introduce several computers, the landlord can consider,

Lenovo

Its Y430 series are among the first in terms of sales volume of computers and attention to the Ultimate Edition.
I want to introduce three models.
Y430a-pse

The configuration is as follows:
Processor Model Intel Core 2 dual-core P7450
Nominal clock speed 2.13 GHz
Front-End bus 1066 MHz
Level 2 Cache 3 MB
Kernel architecture Penryn
Platform technology Intel Platform
Motherboard chipset Intel PM45
Standard memory capacity 2 GB
Memory type DDRIII
Supports up to 4 GB memory
Hard drive/Optical Drive
Hard disk capacity 250 GB
Hard Disk description SATA
Optical Drive Type DVD recorder
Built-in design type Optical Drive
Graphics/sound effects
Low-end independent video card
NVIDIA GeForce 9300 m gs graphics chip
Stream processor count 16
Memory/Bit Width 256 MB/64 bit
Video memory type DDRII
Audio System built-in sound chip
Speaker Dolby certified sound effects, 2.1 audios (stereo speaker + subwoofer)
Display
Screen Size: 14.1 inch
Screen Ratio
Screen Resolution: 1280x800
Screen description LED WXGA
Size/weight
2350 GB laptop weight
Shape: 334x241x26-38mm
Case Material Composite Material
Network Communication
Wireless Network Card Intel 5100AGN
Nic description Mbps Nic
Support for Bluetooth
Modem 56 K
Red outer line infrared interface
Mouse/keyboard
Device touchpad
Keyboard description Lenovo notebook keyboard with high touch
Interface
USB interface: three USB Interfaces
Extended Interface ExpressCard
Card Reader-in-One Card Reader (SD/MMC, xD, MS, MS pro, SD Pro)
Video output HDMI high-definition port and standard VGA Interface
Other interfaces, such as 1394, RJ45, and full-array noise-resistant microphones, support for stereo audio headphone jack/audio output, and
Power supply description
Battery Type 6-core lithium battery
Power adapter 90 W power adapter
Others
Windows Vista Home Basic
Warranty Period: 3 years
Associated Software Package
Random attachment mouse
Optional accessory and notebook Gift Packs (purchased separately)
Other features: 1.3 million pixels support secure and easy-to-use Face Recognition
Quiet Mode with one click
Dolby audio 2.1 audio system
Electrostatic induction multimedia touch operation
Entertainment shuttle Sound Field Control
Hdmi hd output port
Other features: Lenovo one-click rescue/Lenovo flash link Ren Yitong
Environment requirements
Operating temperature 0-35 ℃
Operation humidity parameter error 10%-90% (no condensation)

The price is around 6100, which is definitely worth the money... In particular, it has good heat dissipation performance!

The second is y430-tfi.

Configuration
Intel Core 2 dual core T5800
Nominal 2 GHz clock speed
Front-End bus 800 MHz
Level 2 Cache 2 MB
Kernel architecture Merom
Platform technology: Intel®
Motherboard chipset Intel PM45
Standard memory capacity 2 GB
Memory type DDRIII
Supports up to 4 GB memory
Hard drive/Optical Drive
Hard disk capacity 250 GB
Hard Disk description SATA
Optical Drive Type DVD recorder
Built-in design type Optical Drive
Graphics/sound effects
Low-end independent video card
NVIDIA GeForce 9300 m gs graphics chip
Stream processor count 16
Memory/Bit Width 256 MB & #47 ...... remaining full text>
 
Questions about oracle PL/SQL

Let me talk about my personal experience first: I am a middle school student. I originally studied electronic technology. After I graduated from school, I had a chance to get in touch with ORACLE, it also provides a good learning environment. After a period of time, I learned some basic SQL statements and gradually began to take over more complex work. I developed forms and reports independently, slowly fall in love with this industry, because it always brings many new things, has a lot of learning opportunities, the challenges encountered in the problem and the sense of accomplishment after solving the problem, I have been working in this field for six years. Currently, I am working in a software company. I write a shoe factory ERP program mainly by using the ORACLE development tool Developer to write programs and reports, users can use them to input some simple information and generate some reports Through summarization and calculation, so as to record data and facilitate analysis and statistics.
In fact, learning ORACLE does not require any professional computer knowledge. The key is to have a learning environment at first. It is recommended that someone give us some guidance to understand a rough idea and spend more time reading books, if you belong to someone with strong independent thinking, analytical skills, patience, and skills, I believe that through some time of hard work, you will certainly master this technology, and fall in love with this industry! Come on!