<$BlogRSDUrl$>

Reflections on a Wandering Life.....

Wednesday, November 30, 2022

China's Zero COVID Policy 

Go to Google and type in the word COVID followed by the name of a city. Be sure to spell the name of the city correctly. When it comes up, scroll down until you see the graph and then go to the top left corner of the graph and change it to “All time.” The default is one year, but COVID is not quite three years old, so there’s no reason not to view the total span of its existence.

In the screenshots below, it’s a little confusing to read the dates at the bottom because what I have here are static images, so they don’t show the year (2020, 2021, or 2022), but if you go to Google and do it yourself, the live online version of each graph will have a slider that allows you to go back and forth, and that will show the year.

So what can we conclude from this? Clearly from the graph of Beijing below, the recent spikes have been astronomical compared to before. If you pan across the graph from January 2020 until now, you will see a few blips. At the time that they happened, they appeared as huge spikes, because the scale of the graph was much smaller. If one hundred new cases a day is considered an astronomical number (which it used to be in China), then some of those blips would go almost to the top of the graph. So when you look at a graph like this, it is always important to take note of the scale. Simply put: What is the highest number?

Guangzhou (below) looks similar to Beijing, but if you look at the numbers on the left side, it’s clearly much worse, because the top number is about twice that of Beijing. But although the cases are much more numerous, the pattern is the same. Nothing that happened before begins to compare to how bad it is now.

There are probably a few reasons for these spikes, but I think the main reason is that the latest versions of COVID are much less deadly than before, but they spread much faster. This phenomenon is challenging China’s zero covid policy. But there is something else that is providing a much greater challenge, and that is the current unrest. There have been major demonstrations in several cities. This is unprecedented. But why are people so upset? What has changed?

There are lockdowns, but there have always been lockdowns. In America, they say “lockdowns don’t work.” It’s more accurate to say “American lockdowns don’t work.” You see, for lockdowns to work they have to be total. But you can’t do that in America. American lockdowns are a joke. I remember when CNN had a special feature for Chris Cuomo when he came out of COVID seclusion.. It was a farse. There were videos all over the Internet of him being out on the street during the time that he was supposedly quarantined. That doesn't happen in China.

There are levels of lockdown in China, but they are all pretty Kafkaesque compared to America. Some friends of mine were locked down for about ten days or so because someone in their compound tested positive for COVID. The police put a divice on their door so that if they tried to open it, the police would be notified. But my friends took it in stride.

A friend of mine was just released a couple days ago from a five-day quarantine at her home. In her case, she could leave her apartment, but the door to the building was locked. She could not go outside. I have another friend in Xi’an who was quarantined for some time. In his case, he could leave his apartment, and even leave his building, but not his gated community. By God’s mercy, it has not happened to me. I wouldn’t like it. I guess nobody likes it. But Chinese people have been amazingly accepting of these measures. Look at this graph from Shanghai:

What does this graph say to you? I can tell you what it says to Chinese government officials. They look at this and say, “See, lockdowns work.” Are they right? Well, no doubt they are, you have to admit that. But again, how long can people be expected to tolerate endless lockdowns? As I said, in China, if you’re locked down, you really are locked down. It’s not a suggestion. But most people see that as a needful part of containing COVID and tend to accept it. I do think it adds to the stress that has created the current explosion of anger, but it’s not the main thing.

So what is the main thing? Masks? For the most part, people accept them, I think. In America masks have become a huge point of contention, but not really in China. In America, Republicans see masks as an assault on their freedom. Mask haters in America get really crazy about masks, They see them as sinister and evil. But Democrats are no better. Democrats preach masks, but don't actually wear them. Message to Democrats: If you put your mask on for the cameras and then take it off as soon as the news camera is off, does it not occur to you that a Republican with a cell phone might be there ready to document your hypocrisy? The simple fact is that Americans, both Democrats and Republicans do not like masks and do not wear them.

But in China they are more or less accepted. You see a lot of people wearing them under their chins, but they are there in case they are called for. Here’s the thing: If you show up at the subway station and see a big sign that says, “Everyone who has COVID please wear a mask so that you do not infect other people,” how many people with COVID do you think will be wearing a mask? Obviously none. They’re not stupid. But if the sign tells you that you will not be allowed to board the subway if you are not wearing a mask, then what percentage of those who have COVID will be wearing a mask? Obviously all of them. You see, masks don’t protect you from anything. But they do protect others from you. At least a little bit. Subways are a veritable incubator for viruses like COVID. No surprise that COVID spread like a wildfire in New York during the early days of COVID. So in your normal activity, you will not want to wear a mask. But if you get on the subway, you will wear a mask even though you are not sick, because that is the price you givc in exchange for assurance that everyone else is wearing a mask to protect you.

So if not lockdowns or masks, then what is the issue? But I shouldn’t really imply that lockdowns and masks are not part of the issue. They certainly add to the frustration—especially the lockdowns. I guess you could say that the lockdowns helped to fray the nerves of the people, but they didn’t result in an explosion of anger, because they had a certain legitimacy. The laobaixing accept them as needful, even though they are really getting tired of them.

But the thing that has really incurred the ire of the people is the COVID testing. Testing itself is not new. It has been around since the beginning of COVID. But recently, the government has started to require them for more and more things. Before, you needed a COVID test to get on an airplane. But now you can’t even get on a bus or subway without one. I can’t pinpoint exactly when this change happened, but it must have been sometime in August, because I have to go to the Entry Exit office every month to get a 30 day extension. I went to that office in August with no trouble. But when I tried to go there in September, I was refused entry because I did not have at least a 48 hour test. I was surprised. Nobody had told me anything about this. I had never had a COVID test in my life. Now, I don’t have much to complain about, because I don’t have to go to that office but once a month. So it’s a mild annoyance for me. But what if you work in a government office? You wouldn’t have to get one every day, because most places will accept a 48 hour test. But you would have to get one every two days. There are testing sites set up on the sidewalk around the cities, but the lines can be kinda long, and it’s just more than the masses were willing to put up with.

Back in January, a pregnant woman in labor was denied admission to a hospital because her COVID test had expired. She was forced to wait outside. She began bleeding heavily, so she was finally admitted, but the baby died. But recently the kinds of things that require a COVID test have increased, and well, you know, it just reached a breaking point. I heard that what triggered it was a fire in an apartment building in Ürümqi. I guess some of the doors had been welded shut or something to keep people from leaving, since there was a lockdown. Anyway, ten people were not able to get out, and perished in the flames. So that was the trigger. But the demonstrators are not attacking lockdown. They are tearing down testing stations.

So what will China do? There have to be changes. But China is in between a rock and a hard place. If they declare the pandemic to be endemic, cases will almost surely skyrocket, because there is little or no herd immunity in China (thanks to the Zero COVID policy).I am conflicted about this, because there is no question that I have benefited hugely from China’s policy. But I feel a bit guilty too, because my safety has been at the expense of people who have had to go through a huge amount of hassle that I have not had to deal with. Sometime ago, Singapore officially declared that COVID was now classified as “endemic” rather than “pandemic.” That’s a pretty big change. But can China do that? Is COVID over just because we say it’s over? Look at this graph for New York City:

So you look at this and you say, “ OK, it spiked, but now it’s down to nothing again, so COVID is basically over. Nothing?? Over?? New York’s “nothing” is much higher than any of China’s spikes. But the contrast is much easier to illustrate if we look at death rates rather than new cases. Here’s China. This time, I changed the default setting (you can't see it in this screenshot) from “New Cases” to “Deaths,” hence the grey color:

You see, there’s just no question that China’s draconian COVID restrictions have saved many lives. Hundreds of lives. Thousands of lives. Tens of thousands of lives. Hundreds of thousands of lives. Millions of lives. Millions?? Well, look at this:

China has five times as many people as the United States. But are China's numbers accurate? I don't know. But I think it's pretty clear that but for China's dreaded COVID policies, lots and lots of Chinese people would be dead. There will be changes, because the demonstrations are very concerning to the leadership. People are really, really angry. But I don't know that China is quite ready to give up Zero Covid just yet. That might be awhile.

Comments

Labels: ,

Tuesday, November 29, 2022

User Creation Script 

create user PM31415926 identified by password;
create user PM36211124 identified by password;
create user PM37211101 identified by password;
create user PM37211102 identified by password;
create user PM37211103 identified by password;
create user PM37211104 identified by password;
create user AM37211401 identified by password;
create user AM37211402 identified by password;
create user AM37211404 identified by password;
create user AM37211405 identified by password;
create user AM37211406 identified by password;
create user AM37211407 identified by password;
create user AM37211408 identified by password;
create user AM37211409 identified by password;
create user AM37211410 identified by password;
create user AM37211411 identified by password;
create user AM37211412 identified by password;
create user AM37211413 identified by password;
create user AM37211414 identified by password;
create user AM37211415 identified by password;
create user AM37211416 identified by password;
create user AM37211417 identified by password;
create user AM37211418 identified by password;
create user AM37211419 identified by password;
create user AM37211420 identified by password;
create user AM37211421 identified by password;
create user AM37211422 identified by password;
create user AM37211425 identified by password;
create user AM37211426 identified by password;
create user AM37211427 identified by password;
create user AM37211501 identified by password;
create user AM37211502 identified by password;
create user AM37211503 identified by password;
create user AM37211504 identified by password;
create user AM37211505 identified by password;
create user AM37211506 identified by password;
create user AM37211507 identified by password;
create user AM37211508 identified by password;
create user AM37211509 identified by password;
create user AM37211510 identified by password;
create user AM37211511 identified by password;
create user AM37211512 identified by password;
create user AM37211513 identified by password;
create user AM37211514 identified by password;
create user AM37211515 identified by password;
create user AM37211516 identified by password;
create user AM37211517 identified by password;
create user AM37211518 identified by password;
create user AM37211519 identified by password;
create user AM37211520 identified by password;
create user AM37211521 identified by password;
create user AM37211522 identified by password;
create user AM37211523 identified by password;
create user AM37211524 identified by password;
create user AM37211525 identified by password;
create user AM37211526 identified by password;
create user AM37211527 identified by password;
create user AM37211530 identified by password;
create user AM56000248 identified by password;
create user AM56000255 identified by password;
create user PM37211222 identified by password;
create user AM36211320 identified by password;
create user AM37211423 identified by password;
create user PM37211119 identified by password;
create user PM37211325 identified by password;
create user AM35211119 identified by password;
create user PM35211215 identified by password;
create user PM36211508 identified by password;
create user PM37211105 identified by password;
create user PM37211106 identified by password;
create user PM37211107 identified by password;
create user PM37211108 identified by password;
create user PM37211109 identified by password;
create user PM37211110 identified by password;
create user PM37211111 identified by password;
create user PM37211112 identified by password;
create user PM37211113 identified by password;
create user PM37211114 identified by password;
create user PM37211115 identified by password;
create user PM37211116 identified by password;
create user PM37211117 identified by password;
create user PM37211118 identified by password;
create user PM37211120 identified by password;
create user PM37211121 identified by password;
create user PM37211122 identified by password;
create user PM37211123 identified by password;
create user PM37211124 identified by password;
create user PM37211125 identified by password;
create user PM37211126 identified by password;
create user PM37211127 identified by password;
create user PM37211128 identified by password;
create user PM37211201 identified by password;
create user PM37211202 identified by password;
create user PM37211203 identified by password;
create user PM37211204 identified by password;
create user PM37211205 identified by password;
create user PM37211206 identified by password;
create user PM37211207 identified by password;
create user PM37211208 identified by password;
create user PM37211209 identified by password;
create user PM37211210 identified by password;
create user PM37211211 identified by password;
create user PM37211212 identified by password;
create user PM37211213 identified by password;
create user PM37211215 identified by password;
create user PM37211216 identified by password;
create user PM37211217 identified by password;
create user PM37211218 identified by password;
create user PM37211219 identified by password;
create user PM37211220 identified by password;
create user PM37211221 identified by password;
create user PM37211223 identified by password;
create user PM37211224 identified by password;
create user PM37211225 identified by password;
create user PM37211226 identified by password;
create user PM37211227 identified by password;
create user PM37211228 identified by password;
create user PM37211301 identified by password;
create user PM37211302 identified by password;
create user PM37211303 identified by password;
create user PM37211304 identified by password;
create user PM37211305 identified by password;
create user PM37211306 identified by password;
create user PM37211307 identified by password;
create user PM37211308 identified by password;
create user PM37211309 identified by password;
create user PM37211310 identified by password;
create user PM37211311 identified by password;
create user PM37211312 identified by password;
create user PM37211313 identified by password;
create user PM37211314 identified by password;
create user PM37211315 identified by password;
create user PM37211316 identified by password;
create user PM37211317 identified by password;
create user PM37211318 identified by password;
create user PM37211319 identified by password;
create user PM37211320 identified by password;
create user PM37211321 identified by password;
create user PM37211322 identified by password;
create user PM37211323 identified by password;
create user PM37211324 identified by password;
create user PM37211326 identified by password;
create user PM37211327 identified by password;
create user PM37211328 identified by password;
create user PM56000212 identified by password;
create user PM56000217 identified by password;
create user PM56000232 identified by password;

grant connect, resource to PM31415926 identified by password;
grant connect, resource to PM36211124 identified by password;
grant connect, resource to PM37211101 identified by password;
grant connect, resource to PM37211102 identified by password;
grant connect, resource to PM37211103 identified by password;
grant connect, resource to PM37211104 identified by password;
grant connect, resource to AM37211401 identified by password;
grant connect, resource to AM37211402 identified by password;
grant connect, resource to AM37211404 identified by password;
grant connect, resource to AM37211405 identified by password;
grant connect, resource to AM37211406 identified by password;
grant connect, resource to AM37211407 identified by password;
grant connect, resource to AM37211408 identified by password;
grant connect, resource to AM37211409 identified by password;
grant connect, resource to AM37211410 identified by password;
grant connect, resource to AM37211411 identified by password;
grant connect, resource to AM37211412 identified by password;
grant connect, resource to AM37211413 identified by password;
grant connect, resource to AM37211414 identified by password;
grant connect, resource to AM37211415 identified by password;
grant connect, resource to AM37211416 identified by password;
grant connect, resource to AM37211417 identified by password;
grant connect, resource to AM37211418 identified by password;
grant connect, resource to AM37211419 identified by password;
grant connect, resource to AM37211420 identified by password;
grant connect, resource to AM37211421 identified by password;
grant connect, resource to AM37211422 identified by password;
grant connect, resource to AM37211425 identified by password;
grant connect, resource to AM37211426 identified by password;
grant connect, resource to AM37211427 identified by password;
grant connect, resource to AM37211501 identified by password;
grant connect, resource to AM37211502 identified by password;
grant connect, resource to AM37211503 identified by password;
grant connect, resource to AM37211504 identified by password;
grant connect, resource to AM37211505 identified by password;
grant connect, resource to AM37211506 identified by password;
grant connect, resource to AM37211507 identified by password;
grant connect, resource to AM37211508 identified by password;
grant connect, resource to AM37211509 identified by password;
grant connect, resource to AM37211510 identified by password;
grant connect, resource to AM37211511 identified by password;
grant connect, resource to AM37211512 identified by password;
grant connect, resource to AM37211513 identified by password;
grant connect, resource to AM37211514 identified by password;
grant connect, resource to AM37211515 identified by password;
grant connect, resource to AM37211516 identified by password;
grant connect, resource to AM37211517 identified by password;
grant connect, resource to AM37211518 identified by password;
grant connect, resource to AM37211519 identified by password;
grant connect, resource to AM37211520 identified by password;
grant connect, resource to AM37211521 identified by password;
grant connect, resource to AM37211522 identified by password;
grant connect, resource to AM37211523 identified by password;
grant connect, resource to AM37211524 identified by password;
grant connect, resource to AM37211525 identified by password;
grant connect, resource to AM37211526 identified by password;
grant connect, resource to AM37211527 identified by password;
grant connect, resource to AM37211530 identified by password;
grant connect, resource to AM56000248 identified by password;
grant connect, resource to AM56000255 identified by password;
grant connect, resource to PM37211222 identified by password;
grant connect, resource to AM36211320 identified by password;
grant connect, resource to AM37211423 identified by password;
grant connect, resource to PM37211119 identified by password;
grant connect, resource to PM37211325 identified by password;
grant connect, resource to AM35211119 identified by password;
grant connect, resource to PM35211215 identified by password;
grant connect, resource to PM36211508 identified by password;
grant connect, resource to PM37211105 identified by password;
grant connect, resource to PM37211106 identified by password;
grant connect, resource to PM37211107 identified by password;
grant connect, resource to PM37211108 identified by password;
grant connect, resource to PM37211109 identified by password;
grant connect, resource to PM37211110 identified by password;
grant connect, resource to PM37211111 identified by password;
grant connect, resource to PM37211112 identified by password;
grant connect, resource to PM37211113 identified by password;
grant connect, resource to PM37211114 identified by password;
grant connect, resource to PM37211115 identified by password;
grant connect, resource to PM37211116 identified by password;
grant connect, resource to PM37211117 identified by password;
grant connect, resource to PM37211118 identified by password;
grant connect, resource to PM37211120 identified by password;
grant connect, resource to PM37211121 identified by password;
grant connect, resource to PM37211122 identified by password;
grant connect, resource to PM37211123 identified by password;
grant connect, resource to PM37211124 identified by password;
grant connect, resource to PM37211125 identified by password;
grant connect, resource to PM37211126 identified by password;
grant connect, resource to PM37211127 identified by password;
grant connect, resource to PM37211128 identified by password;
grant connect, resource to PM37211201 identified by password;
grant connect, resource to PM37211202 identified by password;
grant connect, resource to PM37211203 identified by password;
grant connect, resource to PM37211204 identified by password;
grant connect, resource to PM37211205 identified by password;
grant connect, resource to PM37211206 identified by password;
grant connect, resource to PM37211207 identified by password;
grant connect, resource to PM37211208 identified by password;
grant connect, resource to PM37211209 identified by password;
grant connect, resource to PM37211210 identified by password;
grant connect, resource to PM37211211 identified by password;
grant connect, resource to PM37211212 identified by password;
grant connect, resource to PM37211213 identified by password;
grant connect, resource to PM37211215 identified by password;
grant connect, resource to PM37211216 identified by password;
grant connect, resource to PM37211217 identified by password;
grant connect, resource to PM37211218 identified by password;
grant connect, resource to PM37211219 identified by password;
grant connect, resource to PM37211220 identified by password;
grant connect, resource to PM37211221 identified by password;
grant connect, resource to PM37211223 identified by password;
grant connect, resource to PM37211224 identified by password;
grant connect, resource to PM37211225 identified by password;
grant connect, resource to PM37211226 identified by password;
grant connect, resource to PM37211227 identified by password;
grant connect, resource to PM37211228 identified by password;
grant connect, resource to PM37211301 identified by password;
grant connect, resource to PM37211302 identified by password;
grant connect, resource to PM37211303 identified by password;
grant connect, resource to PM37211304 identified by password;
grant connect, resource to PM37211305 identified by password;
grant connect, resource to PM37211306 identified by password;
grant connect, resource to PM37211307 identified by password;
grant connect, resource to PM37211308 identified by password;
grant connect, resource to PM37211309 identified by password;
grant connect, resource to PM37211310 identified by password;
grant connect, resource to PM37211311 identified by password;
grant connect, resource to PM37211312 identified by password;
grant connect, resource to PM37211313 identified by password;
grant connect, resource to PM37211314 identified by password;
grant connect, resource to PM37211315 identified by password;
grant connect, resource to PM37211316 identified by password;
grant connect, resource to PM37211317 identified by password;
grant connect, resource to PM37211318 identified by password;
grant connect, resource to PM37211319 identified by password;
grant connect, resource to PM37211320 identified by password;
grant connect, resource to PM37211321 identified by password;
grant connect, resource to PM37211322 identified by password;
grant connect, resource to PM37211323 identified by password;
grant connect, resource to PM37211324 identified by password;
grant connect, resource to PM37211326 identified by password;
grant connect, resource to PM37211327 identified by password;
grant connect, resource to PM37211328 identified by password;
grant connect, resource to PM56000212 identified by password;
grant connect, resource to PM56000217 identified by password;
grant connect, resource to PM56000232 identified by password;

create view PM31415926.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM36211124.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211101.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211102.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211103.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211104.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211401.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211402.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211404.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211405.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211406.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211407.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211408.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211409.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211410.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211411.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211412.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211413.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211414.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211415.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211416.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211417.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211418.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211419.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211420.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211421.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211422.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211425.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211426.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211427.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211501.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211502.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211503.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211504.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211505.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211506.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211507.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211508.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211509.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211510.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211511.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211512.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211513.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211514.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211515.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211516.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211517.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211518.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211519.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211520.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211521.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211522.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211523.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211524.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211525.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211526.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211527.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211530.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM56000248.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM56000255.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211222.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM36211320.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211423.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211119.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211325.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM35211119.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM35211215.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM36211508.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211105.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211106.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211107.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211108.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211109.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211110.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211111.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211112.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211113.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211114.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211115.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211116.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211117.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211118.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211120.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211121.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211122.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211123.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211124.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211125.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211126.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211127.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211128.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211201.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211202.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211203.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211204.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211205.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211206.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211207.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211208.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211209.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211210.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211211.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211212.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211213.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211215.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211216.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211217.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211218.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211219.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211220.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211221.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211223.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211224.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211225.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211226.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211227.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211228.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211301.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211302.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211303.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211304.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211305.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211306.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211307.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211308.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211309.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211310.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211311.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211312.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211313.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211314.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211315.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211316.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211317.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211318.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211319.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211320.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211321.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211322.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211323.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211324.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211326.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211327.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211328.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM56000212.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM56000217.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM56000232.mygrades as select * from fall2009.studentrecords where student_id = USER;

Monday, November 28, 2022

SQL> @C:\chapter5\loadscores

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

SP2-0310: unable to open file "C:\chapter5\AM37211416.sql"
SP2-0310: unable to open file "C:\chapter5\AM37211417.sql"
SP2-0310: unable to open file "C:\chapter5\AM37211418.sql"

1 row updated.

SP2-0310: unable to open file "C:\chapter5\AM37211420.sql"

1 row updated.

SP2-0310: unable to open file "C:\chapter5\AM37211422.sql"

1 row updated.

SP2-0310: unable to open file "C:\chapter5\AM37211426.sql"

0 rows updated.

0 rows updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

SP2-0310: unable to open file "C:\chapter5\AM37211522.sql"

1 row updated.

SP2-0310: unable to open file "C:\chapter5\AM37211524.sql"

1 row updated.

1 row updated.

1 row updated.

1 row updated.

SP2-0310: unable to open file "C:\chapter5\AM56000248.sql"
SP2-0310: unable to open file "C:\chapter5\AM56000255.sql"
SP2-0310: unable to open file "C:\chapter5\PM31415926.sql"

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

SP2-0310: unable to open file "C:\chapter5\PM37211211.sql"
SP2-0310: unable to open file "C:\chapter5\PM37211212.sql"

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

SP2-0310: unable to open file "C:\chapter5\PM37211227.sql"

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

SP2-0310: unable to open file "C:\chapter5\PM37211312.sql"

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

1 row updated.

SQL> spool off

This page is powered by Blogger. Isn't yours?