Recent content by babe1898

Hi, I'd like to know how to get the instance name of the MSSQL database ? Thank you very much in advance. Regards, Babe

Hi Dagon and SantaMufasa, Thank you very much for your BIG help. It worked! Have a great day!

Hi all, Here's my issue: I created a a table called "TEST" with user student. The user student has the following tablespace: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ USERNAME CREATED PROFILE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE student 22-JUL-08 DEFAULT USERS TEMP teacher 22-JUL-08...

Hi all, Thanks for all your replies... Hi SantaMufasa, I just want to let you know that I'm running the script from Oracle SQl Developer. I tried your suggestion to no avail. Am I missing something? Thanks a lot! I tried the following as suggested by thargtheslayer, and it worked. Thans a...

Hi LKBrwnDBA, Thanks for the reply, When I execute the code that you suggested, the output is shown below: 'DESC'||TABLE_NAME ----------------------------------- desc TABLE_ONE desc TABLE_TWO . . . Am I missing something? Thank you in advance.. Babe

Hi all, Greetings! I'd like to know if it is possible to get columns of all the tables using the command desc? I know the following command would give me the column information of the specified table. desc TABLE_ONE; But, what I want to do this for all the DB tables starting with TABLE. for...

Hi KenCuningham and DeepDiverMom, Thank you so mch for clarifying it...I just didn't get what you meant. Yes, you are right I was not aware of this "START" facility. I'll do it from now on... Thanks again, John

Hi KenCuningham DeepDiverMom, Thank you so mch for clarifying it...I just didn't get what you meant. Yes, you are right I was not aware of this "START" facility. I'll do it from now on... Thanks again, John

Hi KenCunningham, What are you trying to insinuate? Thanks, John

Hi SantaMufasa, A millions thanks to you...It worked! have a great day! Cordially, John

Hi SantaMufasa, Thank you very much! It worked like a charm. Just one thing though, is there a special character that I could use so the SQL command would query for all the tables starting with TEST? For instance, the SQL below should query on all the tables starting with TEST*. I'm not quite...

Hi all, I'd like to know if there's an SQL command that could retrieve the name of the tablespace of my table? I tried the following: desc <Name_Of_Table> But, this command only shows the column(s) of this table. Thank you so much in advance. John

hi lewisp, Thank you so much for this idea...I'll try it and let you know . Thank again. Babe1898

Hi taupirho, Thank you so much for your help. It worked like a charm. It worked for most. But one thing though, does this method has a bug? I tried the following(Ex.1) and it did not give the correct answer. I'm using ORACLE 10g. Do you mind running the following statement and check if you get...

Hi all, The following is my situation: I have Table called Table_Name which contains 100 entries(rows). What I would like to do is count the number of rows of my table which can be done with the function COUNT. Then, use the result in my FOR loop. Now, I'd like to know if it is possible loop...