Search results for query: *

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!

...has the same tablespace as the user "student", and try to do a desc or select on the table "TEST". I got the following error message. SQL> select * from TEST; select * from TEST * ERROR at line 1: ORA-00942: table or view does not exist I did a search on the the erro message...

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

...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 sure if this ispossible in SQL. Any tips would be greatly appreciated. Thanks in advance. select tablespace_name from...

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...

...DECLARE numrecords NUMBER(38); --Number of jobs BEGIN --Count the number of records to be used in a for loop SELECT COUNT(*) INTO numrecords FROM TABLE_NAME; FOR loop_counter IN 0..numrecords LOOP //QUERIES HERE such as SELECT... END LOOP; END...

Sorry, it's TIMESTAMP. Thanks.

Hi all, I'm pretty new to SQL so I only know some of the basic stuffs. I created two columns BEGIN and END both have a TIMESTAMP as datatype. Now. my question is how could I get the diference between these two times/date, meaning the duration between the BEGIN and the END. For example is shown...

Hi ca8msm, Thanks for the information. I'll change this to Oracle forum...Thanks again... babe1898

Hi r937, Thanks again for your rely...Actually, I'm using a Web Application that populates the Tables of my Database(Oracle 10g). From this database, one of the tables contains a column which has the datatype TIMESTAMP. So, basically, my concern is purely "sql query" questioin. Not sure if...

hi r937, yes, the data type is TIMESTAMP. And, the BEGIN and END are just an examples. The following value is the result of the TIMESTAMP datatype. 15-NOV-07 08.52.00.000000 AM Thank you again...