+ Post New Thread
Page 2 of 20 FirstFirst 1 2 3 4 5 12 ... LastLast
Threads 21 to 40 of 390

Forums: SQL PL/SQL

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

  1. How to check no of table created in specific schema

    Hi all, I wanted to know how many table i have created in my schema.i have tried with this query but it is giving wrong information. ...

    Started by laxman, 06-29-2010 11:56 AM
    check, count, created, information, query, schema, select, sql, table, wrong
    • Replies: 4
    • Views: 93
    07-02-2010 04:58 AM Go to last post
  2. Unix Server Time Query

    Hi All, I am a C++ developer and have basic knowledge of oracle & sql. My job profile involves fixing of bugs. While fixing one of such bugs i...

    Started by kruitzpola, 06-23-2010 04:20 PM
    basic, bugs, case, job, oracle, project, server, sql, windows, work
    • Replies: 5
    • Views: 93
    06-30-2010 03:23 PM Go to last post
  3. Conditional FK

    Is it possible to create a conditional FK, the scenario is, i have a table containing pensioner's data. Pension is of different types i.e Old...

    Started by Tariq Bashir Malhi, 06-22-2010 06:34 AM
    2 Pages
    1 2
    conditional, create, data, record, scenario, silent, table, types, validity
    • Replies: 12
    • Views: 198
    06-26-2010 03:32 AM Go to last post
  4. Replacing more then one String with null

    I am facing a simple problem, but could not resolve as yet, i want to replace two string 'M/S' and ' " ' with null, i know this command select...

    Started by Tariq Bashir Malhi, 06-22-2010 05:42 AM
    comma, command, facing, null, problem, replacing, resolve, select, simple, sql, string
    • Replies: 1
    • Views: 52
    06-22-2010 06:06 AM Go to last post
  5. problem with authentication

    Hello, i have a problem with the authentication of my page on "Oracle APEX". Every time I want to register a new registered user to me, the...

    Started by krizza69, 06-21-2010 06:29 PM
    commands, find, logging, oracle, oracle apex, page, password, sql, test, user
    • Replies: 1
    • Views: 77
    06-22-2010 04:06 AM Go to last post
  6. SQLPLUS and CRONTAB

    Hi, Can someone please help me here with this one. This is my script: Code: # more tosh.sh #!/usr/bin/ksh clear . /home/oracle/.profile

    Started by santoshpayal, 06-17-2010 11:24 PM
    app, crontab, good, home, local, morning, oracle, path, run, script, sqlplus
    • Replies: 3
    • Views: 112
    06-18-2010 05:01 AM Go to last post
  7. How to make Fifo and Lifo wise inventory Valuation Report

    My question is I want Stock Report with Costing menthod like First in First out and Last in Last out ok I have 4 Tables 1) Item CREATE TABLE...

    Started by Sharry, 05-31-2009 11:18 AM
    200, amount, called, create, date, hat, highlight, insert, make, number, position, remaining, report, sql
    • Replies: 2
    • Views: 792
    06-15-2010 03:00 AM Go to last post
  8. How to return data structure from stored procedure

    Hello, I have C# application that retrieve data from AQ with some oracle stored procedure, that stored in package. The scheme is: C# code -> Stored...

    Started by rodnower, 06-13-2010 03:07 PM
    application, data, fields, hat, make, oracle, package, schema, sys, table
    • Replies: 0
    • Views: 90
    06-13-2010 03:07 PM Go to last post
  9. Outer join with column value incremented

    Table 1 Split part vechicle count 1 1 V1 10 1 2 v2 20 1 3 v3 30 2 1 v1 10 2 ...

    Started by hiswapna, 06-11-2010 08:30 PM
    column, full, incremented, join, number, outer, output, part, records, table
    • Replies: 2
    • Views: 62
    06-12-2010 04:23 AM Go to last post
  10. Returning Procedure OUT Arguments as a Recordset

    I normally just work with MS Access but need to set up a 3rd party application to retrieve the results of a stored procedure from a customer's Oracle...

    Started by C0D3BR3AK, 06-05-2010 01:01 AM
    customer, database, documentation, find, insert, oracle, recordset, server, sql, update, work
    • Replies: 1
    • Views: 138
    06-05-2010 01:39 AM Go to last post
  11. Info needed about materialized Views

    Can anyone here let me know what is a materialized view with a nice example. Only theoretical declination is not needed. Kindly give a nice coding...

    Started by sandip250382, 06-04-2010 01:46 AM
    give, info, kindly, materialized, needed, nice, tha, view, views
    • Replies: 1
    • Views: 88
    06-04-2010 04:38 AM Go to last post
  12. PL/SQL: ORA-00932: inconsistent datatypes error reg

    Hi all, while compiling one package i am facing one error PL/SQL: ORA-00932: inconsistent datatypes: expected NUMBER got EXP.NUM_ARRAY...

    Started by laxman, 06-02-2010 12:05 PM
    create, data, datatypes, error, inside, number, ora, package, pl/sql, sql
    • Replies: 4
    • Views: 138
    06-03-2010 04:54 AM Go to last post
  13. Procedure compiled with errors - help

    I need little help with my procedure. Procedure is compiling with errors. What could be a problem? Many thx in advance. I submit here full...

    Started by FiZor, 05-25-2010 10:03 PM
    compiled, create, data, documentation, full, ora, red, schema, sys, tables, update
    • Replies: 3
    • Views: 150
    05-29-2010 07:35 PM Go to last post
  14. ORA-06502: PL/SQL: numeric or value error: character string buffer too small

    Hi all, i am facing one ora-error while executing the procedure. ORA-06512: at "Lax.CLOSE_DUP" ORA-06502: PL/SQL: numeric or value error:...

    Started by laxman, 05-27-2010 02:46 PM
    buffer, create, data, day, hat, increase, issue, number, numeric, ora, pl/sql, sql
    • Replies: 5
    • Views: 519
    05-28-2010 12:09 PM Go to last post
  15. Package error- help

    Greetings folks! I am learning procedures, functions and packages. For practice, I use NAVICAT for Oracle and SQL Developer. I need little help...

    Started by FiZor, 05-20-2010 08:09 AM
    functions, key, oracle, package, primary, problem, source, sql, table, update
    • Replies: 6
    • Views: 83
    05-25-2010 09:40 PM Go to last post
  16. refresh oracle schema using stored proedures

    HI, i want to refresh oracle schema using PL/SQL stored procedure. Please help me out.

    Started by khotsuhas, 05-19-2010 10:23 PM
    oracle, pl/sql, procedure, proedures, refresh, schema, sql, stored
    • Replies: 6
    • Views: 137
    05-24-2010 11:40 AM Go to last post
  17. improve oracle dump importing

    Hi, I am importing oracle dump on server using impdp command. And my dump size is about 200MB. Its takes around 4 hrs to import dump. I tried...

    Started by khotsuhas, 05-19-2010 10:29 PM
    comma, command, dump, impdp, importing, improve, oracle, server, size, statistics
    • Replies: 1
    • Views: 82
    05-21-2010 10:10 AM Go to last post
  18. 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
    add, column, comma, command, existing, hat, index, pls, sql, table
    • Replies: 1
    • Views: 79
    05-19-2010 05:21 PM Go to last post
  19. Profortran Exec SQL coredump

    Hello, I am using embedded sql in a Fortran program. Whenever I execute an SQL statement other than connect I get a coredump. So I wrote a small test...

    Started by saracooper, 05-14-2010 09:51 PM
    compile, coredump, delete, deleted, embedded, exec, home, oracle, profortran, program, small, sql, test
    • Replies: 6
    • Views: 130
    05-19-2010 09:02 AM Go to last post
  20. Moved: custom query report for expirycontent

    hi all, am trying develop custom query report for expirt contentenrs. does any one come across with this? any suggetions? what is the sql query...

    Started by karnakar, 05-17-2010 06:25 PM
    custom, query, report, sql, sugge
    • Replies: -
    • Views: -
    05-17-2010 01:18 PM Go to last post

Forum Information and Options

Moderators of this Forum
Users Browsing this Forum

There are currently 13 users browsing this forum. (0 members & 13 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