I have a complete Opt 21 save tape from my current 520 running V6R1. I have the following license pgms installed…Performance tools, DB2 query & SQL Dev kit, WDS, Client access. We found another 520 box(hardware upgraded), it has been wiped clean , no OS. Can I use our opt 21 tape and restore it to [...]
Answer Question | June 10, 2012 9:02 PM
DB2, SQL development, Tape Backups, V6R1
Hi, I was using SQL developer since 2 years, suddenly lost all the existing connections.Tried creating new connections, provided all mandatory fields and clicked “Test”, it was success. But when tried connecting, no response. Also tried importing the connections, but throwing “java.lang.NullpointeException”. What might be the issue?
Answer Question | May 2, 2011 6:46 AM
SQL Database, SQL Developer, SQL development
Can any one please tell me how to know the current password of my pl/sql developer which i am using currently? I know my product code and serial Send me the procedure Thanks in advance PSR.COM
Answer Question | September 13, 2010 8:31 PM
PL/SQL Developer, Security in 2010, SQL Developer, SQL development, SQL passwords, SQL Security, SQL Server
I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name . [strong]Is there a query to find the table and column which contains that data[/strong]
Answer Question | June 9, 2010 4:27 AM
Database query, SQL development
I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name .Is there a query to find the table and column
Answer Question | June 9, 2010 4:40 AM
SQL Database, SQL Developer, SQL development, SQL Server Query
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
Answer Question | October 20, 2009 4:16 PM
CL, SQL, SQL development, STRQMQRY
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 [...]
Answer Question | June 19, 2009 2:12 PM
.NET development, SQL development
I want to select months from January to December using SQL query. I will use this for list item note:- without using PL/SQL and less union.
Answer Question | April 19, 2013 9:04 AM
SQL development, SQL queries
why is the need of psql when the sql is already avaliable.
Answer Question | March 30, 2009 7:43 AM
Oracle SQL, PL/SQL, SQL, SQL development
sql custom messages, how to put a message box if value entered is already taken? and if value entered does not exist?
Answer Question | March 11, 2009 4:14 AM
SQL custom message, SQL development
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 returning anything. [...]
Answer Question | February 10, 2009 2:44 PM
AS/400 SQL View, SQL Developer, SQL development, SQL statements
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 [...]
Answer Question | December 29, 2008 9:34 AM
GROUP BY statement, ORDER BY statement, Query optimization, Query performance, SQL, SQL development, SQL performance, SQL queries, SQL statements
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?
Answer Question | November 21, 2008 8:36 AM
SQL development, SQL Query, SQL tables
Hi, How can I get all the table names of a bib by a SQL-query? Thank you.
Answer Question | April 17, 2013 7:34 AM
Bib tables, SQL, SQL development, SQL Query