Oracle Notes #2

Beatnik on 2005-07-12T13:05:39

SQL Mental note #1:How to create views

 CREATE OR REPLACE VIEW person_ro_view AS
SELECT first_name, last_name, ssn
FROM person
WITH READ ONLY;

Oracle tip #2: Help will actually return help information.. Go figure!

---

SQLplus tip #1

cog on 2005-07-12T13:14:54

IIRC...

c/something/somethingother/

/

(the / by itself will run the last sql statement again, with the changes you've made to it via c/// or something else)