• Finding the number of rows of all tables of a user/schema in Oracle

    how can i know all the table names along with the no. of rows they contain for a user/scema in oracle 9i through sql? plz answer ......

    Chrishram15 pointsBadges:
  • SQL query and Oracle database design help needed

    Sorry for all the confusion with the questions.So let me clear myself,i am doing this not as assignment or homework,but something which interests me and trying to leran.Earlier as I stated that its a part of my school(** well frnakly speaking, it was my plan if i could put this as an item of the...

    Rohit331225 pointsBadges:
  • How can I select unique records from Access based on two criteria

    I need to do the following: SQL = "select amount, count(amount) from table1 group by amount having count(*) =1" This returns all unique records, but I need to add another criteria to that statement ie: I need to select all unique records only if a second value is met as well! This is what I had in...

    Grantp40 pointsBadges:
  • Server 2003 memory performance configuration

    We have a SQL application running in an n-tier environment. Some of the users are complaining about application performance. I am going through the environment looking at all of the elements involved in processing this application. The information below shows all of the server systems involved in...

    Labnuke9932,960 pointsBadges:
  • PL/SQL

    Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and strange it...

    Inprise610 pointsBadges:
  • How do I combine multiple rows into one row?

    I have a table Col1 Col2 Col3 Col4 Col5 ----- ------ ------ ----- ------ 1 abc NULL NULL NULL 1 NULL def NULL NULL 1 NULL NULL ghi NULL 1 NULL NULL NULL jkl I want: Col1 Col2 Col3 Col4 Col5 ----- ------ ------ ----- ------ 1 abc def ghi jkl At first I thougt I could use pivot which I'm not sure how...

    Cathryn35 pointsBadges:
  • SQL Restore takes 6-10 minutes to come up in Enterprise Manager

    SQL Restore takes 6-10 minutes to come up in Enterprise Manager. We have a customer with hundreds of sites, and all their servers do the same thing. We had to roll back after an upgrade and we find that when just selecting "Restore Database" it will seem like Enterprise Manager is hung, but...

    Ulukinatme10 pointsBadges:
  • How do I populate an SQL table created on the fly in RPGLE?

    I am writing a report program where I create a table that is then converted to an Excel spreadsheet using SQL2JXL. I am able to dynamically create a table with Execute Immediate but I have been unable to populate it. The problem is the table name is stored in a variable within the program and I...

    SteveFletcher80 pointsBadges:
  • How to get started in a SQL Environment

    I have been in an AS/400 world up until now. We are moving to SQL for a JDE EnterpriseOne implementation. What would be the best way for me to get up to speed on a SQL Server Database? Thank you for any and all insight.

    Kacerc65 pointsBadges:
  • ORA-03113: end-of-file on communication channel

    I am running a database health report which consists of many SQLs against the data dictionary. Every SQL returns fine except one querying for chained/ migrated rows which takes a little more time, and I get the following: ERROR at line 1: ORA-03113: end-of-file on communication channel I am running...

    OracleATE190 pointsBadges:
  • To retrieve records from SQL Server database

    Hello All, I have a requirement with sql server. Please find below the same. In database say we have a column named "Name" in a table. The records that are available in the table are say like Column_Name = Names Lean Metric Sequence Lean Operation Metric Lean Cleaning and so on.... Now, through...

    Pichha5 pointsBadges:
  • SQL+ running time error

    Can anyone let me know I have a problem to run SQL that after runing sql_build_tables.sql why c:\sql_build_tables.txt is empty (0 byt)- this use Win XP to run However, when I use Vista to run the SQL show Cannot create SPOOL file "c:\sql_build_tables.txt" as show below OBJECT_TYPE COUNT(*)...

    Kchang7474005 pointsBadges:
  • Limit number of rows in a table

    Dear all, I'd just like to ask if anyone can help me find a solution to the following problem: I want to limit the number of records in a table. So when all the available rows are used, the customer can purchase additional ones. Say for example that the customer is allowed to enter 100 sites. When...

    ElArZ15 pointsBadges:
  • SQL Server Query Help Needed

    I have a table with Inventory transacation records. The table contains both Shipment (outgoing) and Receiving (incoming) transactions. I'm trying to write a report that lists both Sales Orders that result in Shipment records and Purchase Orders that result in Receiving records. If I link the...

    Arlin70 pointsBadges:
  • How to find a string in all columns of a table

    I want to search for a string for example "POLARIS" in all the columns of a table ? How to find the string using sql query ?

    Dhumane5 pointsBadges:
  • Help on SQL Query

    Hi, I have a table which has customer order and date in the below format. customer order Date 1 1a 02/10/2008 19:48 1 1b 02/10/2008 18:48 1 1c 02/10/2008 17:48 1 1d 03/10/2008 19:48 2 2a 01/11/2008 01:30 2 2b 02/11/2008 01:30 2 2c 03/11/2008 03:45 2 2d 03/11/2008 03:50 3 3a 06/11/2008 03:50 3 3b...

    GIG240 pointsBadges:
  • Pulling multiple values in the same line in SQL

    Sorry if the title is a bit vague but its almost what am I trying to solve. The best way to explain my issue is this. If I have a table which takes the format.. user_id, error_code. (and other values also). The problem is that the same user_id is listed multiple times for each error_code the user...

    Boardpig90 pointsBadges:
  • Address segregation in SQL 2005

    I am working in SQL 2005 and would like to parse an address filed such as "1234 N CLARK ST APT 111 " into seperate fileds like House Number/Street Name/Street Type ie LN ,ST, or Cir/Apartment Number

    Dkrueger40 pointsBadges:
  • Embedded SQL over multiple physical file members

    Hi, I'm writing a program to process all the members in a physical file. I've done this using embedded SQL because the selection criteria is quite complex. The physical file belongs to an application which I can't change, so I will always have to deal with multiple members. I also don't have the...

    Gilly40023,730 pointsBadges:
  • error in connection between oracle8i&developer2000

    I'm installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I'm installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error "TNS could not resolve." Please provide a solution. Can I use Oracle8i...

    POWERINIT0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following