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!

Register Log in
  • Congratulations derfloh 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: xxing
  • Order by date
  1. xxing

    Search Query Construct-

    Another method Select * from best_Sellers minus Select * from Orders
  2. xxing

    PL SQL help using SQLPlus

    I would suggest you go to the oracle site regards Mark
  3. xxing

    Disk Capacity trends

    Thanks George
  4. xxing

    Disk Capacity trends

    Hi I have to add Disk capacity trending information to data. Need to add future dates with potential disk capacity based on past dates. I have created some dummy data as follows: if object_id('tempdb..#dummytable') is not null drop table #dummytable create table #dummytable ( ServerName...
  5. xxing

    Age Bounds

    Hi I have the following data which i have scripted for your convenience: if object_id('tempdb..#people') is not null drop table #people create table #people ( DOB datetime ) insert into #people values('19630901') insert into #people values('19640901') insert into #people...
  6. xxing

    Selecting Only the Second Row in a Record Pair

    Hi Larry This might help: if object_id('tempdb..#test') is not null drop table #test create table #test ( companyID int ,[$_Paid] decimal(10,2) ,[$_Billed] decimal(10,2) ) insert into #test values(22,181.38,67.88) insert into #test values(22,5986.34,2279.03) insert into #test...
  7. xxing

    Need help with WHERE clause to exclude records

    Hi Jose Sorry I did not read your original emal properly. Try the reverse WHERE ( ProjectedSubmissionDate is not null and ActualSubmittedDate > to_date('1-Dec-10','dd-MON-yy') ) or ( ActualApprovedDate > to_date('1-Dec-10','dd-MON-yy') )...
  8. xxing

    Need help with WHERE clause to exclude records

    Try something like this in the WHERE part of your sql statement WHERE ( ProjectedSubmissionDate is null and ActualSubmittedDate < to_date('1-Dec-10','dd-MON-yy') ) or ( ActualApprovedDate < to_date('1-Dec-10','dd-MON-yy') ); regards Mark
  9. xxing

    Select * from table in a procedure

    I found a website that answered my question. Compared to sql server it's surprisingly difficult to do a simple thing like select * from a table in a stored procedure. This website has a good explanation for SQL Server Programmers http://www.akadia.com/services/ora_return_result_set.html...
  10. xxing

    Select * from table in a procedure

    Hi Carp and Dagon Thank you for replying. Yes I am very new to Oracle. But I have some experience in Sql Server. Background My boss wants to automate the counting of work that comes into his section. What I've done I've created a stored procedure that gets the data from history tables on...
  11. xxing

    Select * from table in a procedure

    Hi I am new to Oracle having a SQL Server background. I like the richness of Oracle, but I am stumped on how to create a stored procedure that selects the columns from a table. Like this: create or replace procedure "P1" is begin select * from T; end; / The code to create Table T is...
  12. xxing

    Spliting comma-delimited column to many columns

    I found this on the internet courtesy Wayne S at http://www.sqlservercentral.com/Forums/Topic845680-338-1.aspx -- if temp table already exists (failed previous run), drop it if OBJECT_ID('tempdb..#test') IS NOT NULL DROP TABLE #test -- simulate the table with the data in it. -- NOTE how your...
  13. xxing

    Spliting comma-delimited column to many columns

    Hi Borislav Thank you for replying. The split function puts the data in rows, not columns. E.g Split function puts Apple,Pear,Kiwifruit,Orange as Fruit1 Apple Pear Kiwifruit Orange I want the data as: Fruit1 Fruit2 Fruit3 Fruit4 Apple Pear Kiwifruit Orange i.e the...
  14. xxing

    Spliting comma-delimited column to many columns

    Hi I would like to split a column containing comma-delimiter data into many columns. e.g TheFruit Apple,Pear,Kiwifruit,Orange to Fruit1 Fruit2 Fruit3 Fruit4 Apple Pear Kiwifruit Orange This is like a split function, but the results appear in columns not in rows...
  15. xxing

    Show the code for a stored procedure

    Hi Thank you all for your help Regards Mark
  16. xxing

    Show the code for a stored procedure

    Hi I created the following code to show the code in my stored procedures: set serveroutput ON set feedback off set linesize 200 set ver off col name format A100 Heading 'List of Stored Procedures' PROMPT -- Show the list of stored procedures for the user name SELECT distinct name FROM...
  17. xxing

    Multi value parameters

    Thanks for your help SantaMufasa
  18. xxing

    Multi value parameters

    Hi Dave Thank you for replying. I have a stored procedure that takes a parameter of a fruit name say Kiwifruit. A select statement will filter the records so only kiwifruit will appear. I would like to change the stored procedure so it can take multi-values of say kiwifruit,pear,orange. These...
  19. xxing

    Multi value parameters

    Hi I have a stored procedure that has a multi-value parameter. The parameter called GetFruitNames will have a value such as 'kiwifruit,pear,orange' In the select statement I have the folowing select fruitnames from fruit where fruitnames in (GetFruitNames) The GetFruitNames...
  20. xxing

    Inserting data into an oracle database

    Hi I worked out how to do this. Here is my code for future reference Sub InsertDataTooOracle(Sql As String) ' The following code inserts data into the oracle database ' Can only run 1 sql statement. Don't use commit. Don't use semi-colon at the end of the sql statement On Error GoTo...

Part and Inventory Search

Back
Top