• Oracle v$ view that dynamically has the names of procedures

    Is there a v$ view where I may find just the names of all the procedures that are currently running in an Oracle database?

    Skabanga5 pointsBadges:
  • Will SAP CRM add to Oracle CRM functional profile

    I was working as Oracle CRM consultant a month back with 2.5 years CRM experience. I have very good knowlwdge & experience of Oracle CRM service modules like Contracts, Field Service, TeleService, Install Base etc. This economic downturn has pushed me out of job. My question is will it be helpful...

    SAPOracleCRM5 pointsBadges:
  • Free Oracle Assessment Exams

    Can someone tell me where I can find free Oracle Assessment exams in preparation for Oracle certifications?

    Stewary5 pointsBadges:
  • 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:
  • 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:
  • PL/SQL: How to check address NOT NULL but can take -(hyphen) instead being NULL

    Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure I can check IF address 3 IS NULL THEN ... END IF But i want to test with test case tat it can't take NULL but...

    Inprise610 pointsBadges:
  • Searching using Oracle Forms

    Hi to all.I am tauqeer.I am using oracle 10g forms developer I want to search some data in the tabular form style in the form based on a query on a text item.I want when i press enter button which is under that text item the data will be displayed in the tabular saction.the text item and enter...

    Raza15 pointsBadges:
  • What are the advantages of Hyperion Planning?

    what is the purpose of this planning, What are the main advantages in this, why customers are looking in to it?

    99898964305 pointsBadges:
  • Inserting 50000 rows using FORALL statement

    How can we insert 50000 rows by using FORALL,please give me entire code?

    Ramesh5530 pointsBadges:
  • Where are Oracle Anonymous Blocks stored?

    Where the anonymous blocks are stored?

    Ramesh5530 pointsBadges:
  • Oracle Data Dictionary

    I have a large Oracle 10g database for which I wish to generate a Data Dictionary DOCUMENT as a contractual deliverable. I need something that I can hand to my customer, not just instructions on where to query the system for the same information. Are there commands in Oracle that will format this...

    OracleATE190 pointsBadges:
  • concatenating rows of a column in oracle 9i sql

    how can i concatenate several rows of a column which is of datatype varchar taking group by of two other columns in oracle 9i sql??

    Chrishram15 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:
  • Oracle Reports6 Live Previewer

    Hi I am using Oracle reports 6 to modify some reports first developed in an earlier version. My problem is that I do not get the editing toolbar showing when I run the report in Live Previewer. Is there some setting somewhere? However, If I develop a new report then the live previewer and all...

    Grayadlam5 pointsBadges:
  • How Do I release unused space from a tablespace after dropping a blob table

    I have a 30 GB BLOB table in a 162 GB tablespace. After I used the online table reorg to move this BLOB table and its BLOB index to another tablespace, Toad tells me that I have about 35 GB free. However, I can not reduce the size of this tablespace (i.e, resize the datafiles associated with this...

    Hmhora10 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:
  • Does Oracle Stream data replication requires identical tables structure between source and Target Databases?

    We are considering the use of Oracle Data Stream to replicate data from operations database to a separate Helpdesk database. Our users require near real-time data loaded in the helpdesk database. What are the constraints imposed by Oracle streams for table design? Does it require for tables...

    Ss20095 pointsBadges:
  • PL/SQL – Attribute to test not null and can take specific value instead

    Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure

    Inprise610 pointsBadges:
  • Errors in Creating Oracle packages

    Can anybody plz find out the error in the following code?? plz reply back. SQL> CREATE OR REPLACE package body PKG_IMAGEM1 2 as 3 PROCEDURE IMGINSERT1(P_Region IN VARCHAR2, 4 P_College IN VARCHAR2, 5 P_CourseCat in varchar2, 6 P_CourseName in varchar2, 7 P_StudentName in varchar2, 8 P_ID in...

    Shreeshonkar10 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