SQL PL/SQL Forums

in Oracle Forums Community, Oracle SQL PL/SQL queries, DML DDL statements, packages, procedures, functions, sequences and triggers

+ Post New Topic
Page 1 of 20 1 2 3 4 11 ... LastLast
Threads 1 to 20 of 399

Forums: SQL PL/SQL

Oracle SQL PL/SQL queries, DML DDL statements, packages, procedures, functions, sequences and triggers

  1. Error PLS-00103 on compiling ORACLE stored procedure.

    Hi All, I am a C++ developer with only basic knowledge of ORACLE. The solution for a bug that I have to fix, needs me to make some changes to...

    Started by kruitzpola, 09-01-2010 03:52 PM
    • Replies: 6
    • Views: 71
    zargon
    Yesterday 09:12 PM Go to last post

  2. Convert Oracle Timestamp to Date

    Hi guys just a simple issue, how does one convert Oracle Timestamp to Date? I have a table where I have a timestamp column. I need it in a date...

    Started by amy85, 04-04-2009 08:25 AM
    • Replies: 4
    • Views: 31,643
    damolat
    08-31-2010 10:18 AM Go to last post

  3. Error on sql loader log file

    Hello All, I have been trying to load data unto an empldr table. But when I invoke the loader, all is well as it brings back a message saying: ...

    Started by Aj_aaron2002@yahoo.co.uk, 08-24-2010 03:43 PM
    • Replies: 3
    • Views: 81
    zargon
    08-24-2010 11:48 PM Go to last post

  4. Red face Just The Latest Please!

    I'm trying to select the most recent price (ITEM_PRICE) from many in TABLE_REF_PRICES for each of 142K unique products in TABLE_REF_PRODUCTS based...

    Started by Jersey526, 08-22-2010 06:42 PM
    • Replies: 4
    • Views: 70
    Jersey526
    08-24-2010 04:42 PM Go to last post

  5. ORA-01086: savepoint never established

    I am trying to set a savepoint and the rollback to that point when I have a problem. But I get the following message: "SQL execution error,...

    Started by artmast, 08-21-2010 08:13 PM
    • Replies: 1
    • Views: 87
    zargon
    08-21-2010 11:10 PM Go to last post

  6. Question Question about DBMS_REPCAT_INTERNAL_PACKAGE

    I am a .NET programmer and I am new to the oracle REPLICATION world. I have come across the following replications packages/procedures: procedure...

    Started by tripower, 08-12-2010 05:56 PM
    • Replies: 1
    • Views: 78
    zargon
    08-12-2010 09:22 PM Go to last post

  7. Applying CHECK Constraint

    I want to apply a constraint on a table, if column c1 or c2 is not null then c3 should also be not null. I try but receive ORA-02438 error message....

    Started by Tariq Bashir Malhi, 08-12-2010 06:13 AM
    • Replies: 3
    • Views: 73
    rajavu
    08-12-2010 09:49 AM Go to last post

  8. ORA-00069 cannot acquire lock

    Hi, I am getting the Oracle Database error "ORA-00069 cannot acquire lock -- table locks disabled for string" in a stored proc. According to some...

    Started by artmast, 07-31-2010 11:08 PM
    • Replies: 2
    • Views: 66
    rajavu
    08-11-2010 07:21 AM Go to last post

  9. Need a way to join the table using sql query

    Hi all, i have one requirement to get the output from an existing query including the records stored in one Log table.The information...

    Started by laxman, 07-19-2010 10:44 AM
    • Replies: 1
    • Views: 72
    rajavu
    08-11-2010 05:58 AM Go to last post

  10. how to modify an index created on a table in sql

    hi, we have created index1 on column1 of a table in sql. Now we want to add column2 of same table to that index. Can we modify existing index to...

    Started by bujji_22, 05-19-2010 01:57 PM
    • Replies: 4
    • Views: 109
    rajavu
    08-11-2010 05:28 AM Go to last post

  11. How to exclude some one from a table

    I need to calculate a highest salary and I need to exclude. Some one from this. How do I do that this is my code so far. I need to remove the owner...

    Started by cfoucault1, 07-15-2010 07:34 PM
    • Replies: 4
    • Views: 86
    zargon
    08-11-2010 12:19 AM Go to last post

  12. Help me to solve this query

    A table namely emp has two fields, empno and salary. There are total 20 tuples(records ) in the table. Salary can be same for more than one employee....

    Started by sandip250382, 06-29-2010 05:52 PM
    2 Pages •
    1 2
    • Replies: 16
    • Views: 245
    zargon
    08-10-2010 11:20 PM Go to last post

  13. ORACLE SQL Query to filter results for Date = "the date seven days ago."

    Hi, I am trying to generate reports on OBIEE for which I may have to write a SQL query for the filter. The Filter must generate results for Data...

    Started by mahalaxminanya, 07-12-2010 08:19 PM
    • Replies: 3
    • Views: 133
    ashishb01
    08-09-2010 07:29 PM Go to last post

  14. Table Value Sets

    Hi All, My requirement is to pull data between two dates in Oracle Apps. Ex: I want to display invoice data between date1 and date2. for...

    Started by kiran.marla, 07-20-2010 06:37 PM
    • Replies: 9
    • Views: 152
    rajavu
    08-03-2010 07:11 AM Go to last post

  15. Adding a column between existing columns

    I want to add some new columns in an existing table that has over 10 millions rows, but not at the end of existing columns, my requirement is such i...

    Started by Tariq Bashir Malhi, 07-08-2010 07:01 AM
    • Replies: 3
    • Views: 132
    rajavu
    07-29-2010 05:42 AM Go to last post

  16. SQL Tuning ?

    Please help me in SQL Tuning in step by step method. what is EXPLAIN PLAN, tkprof, Trace ? Kiran Marla

    Started by kiran.marla, 07-28-2010 05:48 AM
    • Replies: 3
    • Views: 77
    kiran.marla
    07-29-2010 02:39 AM Go to last post

  17. unable to access remote database object using database link

    Hi all, I have created a database link to a remote server SQL> create database link remote_link connect to lax_dba identified by...

    Started by laxman, 07-26-2010 02:26 PM
    • Replies: 1
    • Views: 63
    rajavu
    07-27-2010 05:15 AM Go to last post

  18. How to Revoke 'ANY' priviliges being granted to Non-DBA users

    Hi all, I need to be revoked all 'ANY' privileges that have been granted to all non-DBA user or Role in the database. To achieve this what...

    Started by laxman, 07-26-2010 02:14 PM
    • Replies: 1
    • Views: 56
    zargon
    07-26-2010 03:00 PM Go to last post

  19. how can i get same value in return?

    i have some problem from converting firebird to oracle select count(*) into v_is_allowed from view_downline(v_agen_id) where...

    Started by Ch1bZ, 07-20-2010 03:17 AM
    • Replies: 1
    • Views: 59
    rajavu
    07-26-2010 07:43 AM Go to last post

  20. SQL Query

    The following is the question: QRY 1: I have a table "A". Data is selected from table A based on some condition. Then , Based on a value of...

    Started by nandhu, 07-19-2010 04:25 PM
    • Replies: 1
    • Views: 61
    rajavu
    07-26-2010 07:36 AM Go to last post
+ Post New Topic
Page 1 of 20 1 2 3 4 11 ... LastLast

Forum Information and Options

Moderators of this Forum
Users Browsing this Forum

There are currently 4 users browsing this forum. (0 members & 4 guests)

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules