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

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

Hello Everyone, I would to know what the JAVA API so that i could print a file to a printer or to postcript. Can anyone help me on this...I have a project which is due very soon..thanks

Hello everyone... I'm using sql queries(insert)..but i don't know how to use the @@identity? Let's say, I JUST INSERTED A NEW ROW...THEN to get the the ID of that row is the follwing... SELECT @@IDENTITY IS THIS RIGHT? THANKS

Hello everyone... I'm using Microsoft access for my datababe AND i want to get the ID(PRIMARY KEY) of the row that has been inserted. Also i'm NOT USING auto generated number for the ID. What is the sql command for this?Could anyone help me...thanks

Hello Everyone, I'm using Micorsoft Access and the key of one of the table,say ID, is automatically generated. So, after inserting a row, i would like to get the row number(ID) of the row that has been inserted.What is the SQL command for this? Could anyone help me on this? Thanks