• Which tool is best in all aspects?

    Which tool is best in all aspects - speed, performance, user friendly, to do all activities etc - PL/SQL Developer or SQL Developer or TOAD

    RajeshITK65 pointsBadges:
  • STRQMQRY in batch on i5

    Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen

    TOASTY35 pointsBadges:
  • SQL Developer: missing expression on insert into with select rownum

    insert into TEMPLE_BDMS.TEMP_QSP values ( select rownum as uniqrownum, doc_id, doc_type, barcode2, barcode3, barcode4, routing_status, scan_date, assignee, scanner, scan_station, pfile_name, new_doc_id, new_doc_type, new_doc_type2 from TEMPLE_BDMS.QSP_SOURCE where pfile_name not like '%_0001.%' ) I...

    APB10 pointsBadges:
  • SQL image data type

    Hello expert, I have a developer using .NET front end then call function with image data type to load data into #temp table. He said that will be easy. I need help with few questions. 1. Using image, xml and ntext, will those data type effect performance. 2. If I do not want to use those data type,...

    Maylee6330 pointsBadges:
  • What is the difference between software package in SQL and PL/SQL

    why is the need of psql when the sql is already avaliable.

    Krrishkundan5 pointsBadges:
  • Custom alert messages with SQL

    sql custom messages, how to put a message box if value entered is already taken? and if value entered does not exist?

    Yosbeeebajay10 pointsBadges:
  • SQL Developer Views and Programs

    I created a view to simplify the cursor within the package body. The SQL statement being used works as expected in SQL Developer but the program returns zero records. The program worked correctly before replacing one of the tables with this view. Not sure why all of a sudden the sql statement isn't...

    Petpat12370 pointsBadges:
  • Query performance and tuning

    Hi, I wanted know as to what I can do to my query so that it improves in performance.RIght now it it taking 3-4 hrs because of the large no of records in the DB.If i remove the group by and order by clause for the same no of records it is fast but when it does sorting it hangs.But I need to do the...

    Mingley5 pointsBadges:
  • Need SQL query

    Hi, I have a emp table in which I have 7 columns and hiredate is one of the columns. I need to query for the hiredate which has maximum number of employees joined the company on a particular date?

    Kirankg5 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.

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

Following