Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: theshowmecanuck
- Content: Threads
- Order by date
-
how do I... pseudo dynamic sql (like Oracle)?
I am trying to write some pseudo dynamic sql to generate a script. It is something I have done much of in Oracle and SQL Server, but I can't figure out the data dictionary for MySQL Example (what I would do in Oracle): select "select " || column_name || " from " || table_name || ";" from...- theshowmecanuck
- Thread
- Replies: 8
- Forum: MySQL
-
retreive outside data in a trigger or procedure
This is an odd request... I have a friend who asked if there was a way to pull data from a web page from within a trigger or stored procedure using a 'get' type of command and specifying a URL. It sounded pretty odd to me... and very unlikely, but what the heck, there are a lot of folks with...- theshowmecanuck
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
FIRST_ROWS optimizer question
I am trying to get some information on the FIRST_ROWS optimizer option in Oracle 9i. I know that this option tells the optimizer to return the first row of the result set as fast as possible. However, I know that in many product's cost based optimizers, that when the first rows type of option...- theshowmecanuck
- Thread
- Replies: 7
- Forum: Oracle: All versions
