get the value from XML in a sql table
i created a table which contains many columns. out of that one column is having xml codings which are saved as xml info.  We are having number of parameters in one row data of that xml info. Like this we are having multiple rows. I want to select the value from the xml column of [...]

Answer Question   |  February 28, 2012  10:17 AM
SQL Developer, TOAD

How to extract database with SQL Developer
Hi there… How do I extract a database created in Oracle APEX, using Oracle SQL Developer tool??? Thanx in advance

Answer Question   |  June 13, 2011  12:38 PM
Oracle, Oracle Apex, Oracle SQL Developer, SQL Developer

Running a query in Oracle 10g
How to rung query in oracle 10 g, if i run query it will be error coming, it will ask connection. can u tell me how connect databse file in sql developer which is install from oracle.com?

Answer Question   |  June 1, 2011  5:53 AM
Oracle 10g, Oracle Query, Oracle SQL Developer, SQL Developer

unable to create a connection to DB from SQL developer
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

Why can’t I connect to Oracle DB from virtual xp running under windows 7 host
I am running plsqldeveloper on a windows xp virtual machine. (Created on a windows 7 box). When I start plsql developer on the virtual xp machine I type in a vallid Username/Password there are no Databases in the drop down list so I type in a valid database name then I get the following error: [...]

Answer Question   |  December 7, 2010  5:54 PM
Oracle, Oracle Database, PL/SQL Developer, SQL Developer, Virtual PC, Windows XP, Windows XP Virtual Machines

Getting password when we know Product Code and Serial in Pl/SQL Developer
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

ASP Web page database?
I want to do a web page with ASP.NET I already make another one using Access as my database manager but now is a bigger project so I want to know what can I use for create the database or if it’s good still with access. (I Know basically  ”everything” is SQL but please give [...]

Answer Question   |  August 18, 2010  5:17 PM
ASP.NET, ASP.NET Web applications, SQL Access, SQL Database, SQL Developer

SQL server query to search for table and column data in database
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

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

Answer Question   |  May 20, 2010  6:38 AM
Oracle, PL/SQL Developer, SQL Developer, TOAD

create a procedure
i want to create a procedure it should be able to audit any change done in the database ie. drop/delete of schema tables. the procedure should be able write audited data into a remote server machine inaccessible by the system manager/dba.

Answer Question   |  March 17, 2010  6:24 AM
DELETE statement, DROP, SQL Developer

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 can run the select fine (it returns rows), but when I try to insert with the select, I get an ORA-00936 missing expression [...]

Answer Question   |  August 13, 2009  5:04 PM
ORA-00936, Oracle developers, SQL Developer

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 returning anything. [...]

Answer Question   |  February 10, 2009  2:44 PM
AS/400 SQL View, SQL Developer, SQL development, SQL statements