• SQL: Remove specific records from one table based on records present in another table.

    Suppose we have two tables T1 and T2 as described below: T1:- Col 1 Col2 Valid 1 a 120 2 b 232 1 b 435 3 a 123 2 c 532 T2:- Col 1 Col2 Invalid 1 a 1133 2 b 2321 2 a 4234 Now what can be the simplest query to remove all the records from T1 which are also present in T2 having the same values of both...

    raghvendra25125 pointsBadges:
  • Oracle SQL in TOAD

    Run a query that returns the number of trouble tickets in the VTM024… table, but only the ones created in the year 2015. Note: when setting the where criteria, use a function to extract the Year portion from the timestamp field. Using the Year function in the first answer, write SQL that shows...

    faizanahmad2330 pointsBadges:
  • Send email through procedure in PL/SQL

    Dear Team, I want to make a procedure through which I can send email to my team mail id. Actually there are number of procedures running daily in our system. So I want to send the status of each procedure means if procedure is getting success,failed or running. If the procedure is in running state...

    Biswa9215 pointsBadges:
  • How to avoid TAF in Oracle database

    I have one table, and indexes are created for all the columns still. I'm getting table access full for the same table, please tell me how to avoid TAF in Oracle database.

    Pankaj77215 pointsBadges:
  • Query related to Global Temporary Table

    When should we use a GTT and When should we use a collection?

    karthikeyadarbha5 pointsBadges:
  • Oracle 10g: How many rows were affected by PL/SQL update

    For Oracle 10g, I'm running a PL/SQL function that updates several rows. Is there a way for me to see how many rows were affected? I need this number in PL/SQL. Thank you.

    ITKE1,047,940 pointsBadges:
  • How to determine if field is null in PL/SQL or Oracle

    How can I tell if a field is null in Oracle - PL/SQL? I know how to do it using SQL Server, IsNull() but I'm struggling with this. Can anyone help?

    ITKE1,047,940 pointsBadges:
  • IN PL/SQL how to declare and use ‘STATIC DATA TYPE like C’

    Hi All, Can anybody help me to declare a variable having the similar propery of 'STATIC DATA TYPE IN C'. Means declare a variable and initialize it inside the procedure and called the procedure recursively but each time it is initializing the variable. I want any mechanism in PL/SQL that will make...

    Oracle10g4developers5 pointsBadges:
  • How to insert CSV file into Oracle database through PL/SQL procedure

    Hi all, I have a CSV file and I have to insert its data into the Oracle database. Is it possible through creating procedure if yes then give me any solution, I need it urgently. Thanks in advance.

    mollarubia5 pointsBadges:
  • Error(10601,4): PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:

    When I'm compiling a package, I'm getting below error. Error(10601,4): PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin end function pragma procedure. I'm using is Oracle 11g in SQL Developer.

    Vimalkv15 pointsBadges:
  • Sending an email alert to addresses in the database and getting a return email as notification

    Dear Sir/Madam, I have this PL/SQL Store Procedure that sends out email with query result in HTML table format to email addresses in my database but I want to be notified what was the data send to each customer email every time a email is send. Can anybody help me with how to get this done?

    ADagoseh25 pointsBadges:
  • Oracle FK Dependencies

    A query I run accesses multiple tables. One of those tables has a FK dependency on a column, which is populated by the application and hardcoded as a single value for all records. So in the where clause when im joining all the tables to get the data required, it is only pulling data for that...

    Rishik015 pointsBadges:
  • Procedure to send reminder emails

    I tried executing the below script as procedure, but it throws error as in "PL/SQL: ORA-00942: table or view does not exist". This error is coming on line where I am using dba_users table along with a table in which I have stored the email_addresses. For e.g :- CURSOR c1 IS SELECT...

    sunshine125 pointsBadges:
  • Connect remote Oracle database through PL/SQL Developer

    We have an Oracle database which connects to a remote IP address. Is there a way we connect to it through PL/SQL Developer? Thank you very much.

    ITKE1,047,940 pointsBadges:
  • Search within all SAP ABAP code for a variable.

    I used a variable called - myvar. I am uncertain where all i have used it during the ABAP development. How can I search all ABAP code ever written in SAP for this variable? In other words, how can I search SAP ABAP code for a variable, key word etc. For example, in Oracle we had all_source,...

    gram7720 pointsBadges:
  • Create a trigger to call a procedure

    HI, I am trying to create a trigger where is checks for a condition every time an insert or delete happens on the table and then calls a procedure. Any help is appreciated.PROCEDURE: ============ CREATE OR REPLACE PROCEDURE "GFMPNRT"."PP_CLEANUP_ALERTS_FOR_POC" (v_ACTION_LEVEL_KEY IN VARCHAR2,...

    Nagesh198540 pointsBadges:
  • How to execute a message in PL/SQL from SQL command prompt

    Sir, I have written a small message using PL/SQL. When I execute that query in SQL CMD prompt, I'm unable to see my output. How can I execute my output in SQL?

    kothias5 pointsBadges:
  • Formatting PL/SQL code in SQL Developer

    Hi experts, I would like to know some keyboard shortcuts and clever formatting on PL/SQL codes in SQL Developer. Please help me out with some hints for this. Thanks in advance.

    Inprise610 pointsBadges:
  • PL/SQL – How to make a check whether the attribute is positive or zero

    Hi Experts, How to make a check on attribute(NUMBER) is positive or zero?

    Inprise610 pointsBadges:
  • Receiving Rep: 1401: cf titleformula fatal PL/SQL error occurred, ORA:06508 error

    Sir, I keep having problems with this error. Please help me find the solution: Rep: 1401: cf titleformula fatal PL/SQL error occurred, ORA:06508

    adilmehfooz5 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