|
|
Browse by Tags
- 2
- 2003
- 2005
- 3
- access
- access 2007
- all
- alter
- array
- base
- batch
- between
- book
- charts
- checkboxlist
- combine
- compare
- copy
- count
- crystal
- data
- database
- databases
- db2
- delete
- design
- different
- disadvantages
- drop
- Excel
- export
- file
- find
- finding
- flat
- fold
- form
- forms
- found
- from
- full
- gl
- grant
- gridview
- group
- hangs
- have
- having
- how
- html
- i
- inner
- insert
- join
- joining
- key
- large
- linked
- linking
- list
- loader
- max
- merge
- move
- multiple
- mysql
- nested
- number
- one
- oracle
- order
- outer
- printing
- procedure
- query
- records
- relationships
- relink
- report
- reports
- rows
- same
- schema
- select
- server
- servers
- several
- show
- sql
- statement
- sybase
- system
- temp
- three
- truncate
- two
- union
- update
- user
- view
-
sqlplus show all tables command
I want to make sure i created a table in the oracle 8i DB I need the simple command to show me all the tables in the DB. I use the system/manager to create the table and it should be there I think. My DB is on solaris but I think it should be the same in NT I tried echo "select * from all_tables"... -
List all tables in a schema?
How can I list all tables in a schema? I would like to build a reporting tool, which I can run and it will list all tables in a schema. It would have to be done via a query (odbc). In the future, I would like to convert it to a Stored procedure, but I need to access it via a query now. TIA, astro -
Update from multiple tables
The question below comes from this site. It's an accepted answer. However, this syntax doesn't work for me. I get an error on the comma (after carts c,) that I'm missing the SET keyword. 1) Is the syntax below incorrect, and 2) if it is incorrect, then how can you update multiple rows using... -
INSERT INTO Multiple Tables
Hello, I have 2 tables, obviously joined on a key. I want to insert data into 1 table, and then insert multiple values into the second table using the autonumber that was assigned to the first one. In otherwards table1 has an autonumber field that is its primary key. and this field is linked to table2... -
sort order for SHOW TABLES query
easy one, I hope... can I customize the order of the results when doing a SHOW TABLES query? -Brian -
SQL Database 2005 joining 5 to 8 tables
Can somebody please provide a sample code on how will I join 5-8 tables. Thanks. -
Pasting word tables to InDesign CS2
Hi, How do I paste word tables in InDesign CS2, yet keeping the rows and cells? So far all it gave me was the text with tabs between what used to be cells. I want the table lines to be pasted as well. Any idea? Stilgar. -
count total of 2 tables
Hi, I need to count total number of records present in 2 tables. I am having a working query for SQL Server but it doesn't work in mySQL. Any help please? select sum(a.total1) from (select count(*) total1 from CoreJava_Code union all select count(*) total from CoreJava_File)a -
OUTER JOIN 2 (or more) tables at once
I need to know if it is possible to OUTER JOIN multiple tables at the same time. this would be like OUTER JOINing 2 queries together this code works (but is a pain to update and takes forever to run): SELECT transactions.ID, transactions.ProdID, transactions.RatePlan, transactions.ServArea, products... -
List all tables in a database
What is the SQL command to list all tables in a database? What is the SQL command to list all columns in a table?