I have a query that give me result in that way:Key, Category, Machine, Date, ResultSo I have a value on each row of the query result. But I want to present my data in a columnar way, like this: ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10053730.html
Zones:
MS AccessDate Answered: 05/20/1998 Rating: 7.4 Views: 0
I'm using SQL*Plus 3.3.2.0.2. I need to wrap a column in an extract so that it produces a record type followed by a single line with a '1' on it like:
1BMyrecordishere...
1
1BMyotherrecordishere.....
http://www.experts-exchange.com/Database/Oracle/Q_10133248.html
Zones:
OracleDate Answered: 03/01/1999 Rating: 7.6 Views: 0
I have a table that has "First_name" and "Last_Name" and I'm using ASP to do a simple search and compile tepehone numbers. I have one text field an use this source code:
<% If request.form("max...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10222123.html
Zones:
MS SQL ServerDate Answered: 03/03/2002 Rating: 7.8 Views: 0
How do i add or update a comment for a table
as well comments for columns?
Like For eg., Department
I want to add a comment to this table without having a seperate column for comments.
De...
http://www.experts-exchange.com/Database/Oracle/Q_10290259.html
Zones:
OracleDate Answered: 02/04/2000 Rating: 7.8 Views: 0
Hello, experts!
1)I have a CORRECT MSSQL 7.0 DataBase with approx. 30 tables in it.
2)I perform a complicated multi-select query with table joins inside. And here is the query code.
3)I get a sy...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10307255.html
Zones:
MS SQL ServerDate Answered: 03/08/2000 Rating: 5.2 Views: 0
Hello......
How can I return the length of a datatype for a column as an integer?
regards
http://www.experts-exchange.com/Database/Oracle/Q_10354247.html
Zones:
OracleDate Answered: 05/27/2000 Rating: 6.6 Views: 0
How do I use teh Alter Table statement to:
Change a Column Name
Delete a Column
http://www.experts-exchange.com/Database/Oracle/Q_11211057.html
Zones:
OracleDate Answered: 09/11/2000 Rating: 7.6 Views: 0
I have a Main table, with fields:
Activity, RSC, Loc, Dept, Jan-99, Feb-99, Mar-99.... Dec-00
I have a form to select the month to be updated.
I have an update query:
Activity, RSC, Loc, De...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_11268356.html
Zones:
MS AccessDate Answered: 07/30/2001 Rating: 9.2 Views: 0
Eg.
SELECT sysdate OCT, sysdate -100 JUL FROM dual;
OCT JUL
--------- ---------
12-OCT-00 04-JUL-00
Above statement has the sysdate values named as 'OCT', 'JUL'. I want to name this ...
http://www.experts-exchange.com/Database/Oracle/Q_11529458.html
Zones:
OracleDate Answered: 10/19/2000 Rating: 6.2 Views: 0
Can you remove a column from an existing table if the column has no data?
If so How
Thanx
http://www.experts-exchange.com/Database/Oracle/Q_11811258.html
Zones:
OracleDate Answered: 11/09/2000 Rating: 8.8 Views: 0
