1
  • 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 that table using...

    Rithunsi5 pointsBadges:
  • 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

    pforos220 pointsBadges:
  • 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?

    Varsha500950 pointsBadges:
  • 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...

    Abc130 pointsBadges:
  • 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:...

    PLSqlWannaB30 pointsBadges:
  • 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

    PSRDOTCOM5 pointsBadges:
  • 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 me a good...

    Eddy20 pointsBadges:
  • 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

    Linu438910 pointsBadges:
  • 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:
  • 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.

    Shwetamishra5 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 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:
1

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