tribal Posted February 27 Report Share Posted February 27 got a ? for ya. whats the diff between the SPOOL command and the COMMIT command??also say im writing in tables and relations. how do i save my worksession, not the query results, but just the schemas of the tables so i can edit and create new ones in the future? what command lets me save this worksession?? thanxoh and one more ?how do i bring back the last typed command line so i dont have to retype the entire table schema? like if i just typed in:SQL> create table Student(sname varchar (20),sid number,address varchar(30),primary key (sid)), <--- i accidentally typed , instead of ; and pressed enterhow do i get all that text back without retyping the whole schema again? thanx Quote Link to comment Share on other sites More sharing options...
scoob-e Posted February 27 Report Share Posted February 27 the commit command basically saves any unsaved updates to the database and all extant save points and locks are releasedthe spool command is used to capture any output by SQL to a file. Quote Link to comment Share on other sites More sharing options...
scoob-e Posted February 27 Report Share Posted February 27 i dont want to try and help you any further because im not THAT informed about SQL, so i dont wanna try and sound smart and tell you something that is totally wrong or will throw you totally off track. hope the above information helped you though. Quote Link to comment Share on other sites More sharing options...
tribal Posted February 27 Author Report Share Posted February 27 thanx scooby, im gona get one of em dummy books tomorro, or maybe those Peachpit press books. theyre excellent. thanx anyway Quote Link to comment Share on other sites More sharing options...
acura Posted February 27 Report Share Posted February 27 SQL is a bitch , so is converting tables to 1-4 normal form Quote Link to comment Share on other sites More sharing options...
thehacker Posted February 27 Report Share Posted February 27 what environment you runnin?all your questions sound specific to your choice of db platform. Quote Link to comment Share on other sites More sharing options...
tribal Posted February 27 Author Report Share Posted February 27 its SQLPlus, but i guess i cant save worksessions. a friend just explained that all tables are saved in same file. sql is great, except i gotta get used to it. Quote Link to comment Share on other sites More sharing options...
barvybe Posted February 27 Report Share Posted February 27 Hacker is right btw....questions about how to bring up the last command and stuff vary depending on your interface. Are u using the interface Oracle provides for the client? or a package like SQL Navigator? or a terminal emulator like Reflection?SQL is great...pure logic. Quote Link to comment Share on other sites More sharing options...
crobra Posted February 27 Report Share Posted February 27 Originally posted by barvybe Hacker is right btw....questions about how to bring up the last command and stuff vary depending on your interface. Are u using the interface Oracle provides for the client? or a package like SQL Navigator? or a terminal emulator like Reflection?SQL is great...pure logic. wtf???? :confused: I thought you were a mythology major in college?I guess Harvard myth. program is really well rounded!! Quote Link to comment Share on other sites More sharing options...
barvybe Posted February 27 Report Share Posted February 27 Me? Harvard?that's more like a folktale Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.