+ 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
    laxman
    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
    zargon
    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
    Sadik
    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
    Tariq Bashir Malhi
    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
    zargon
    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
    zargon
    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
    samit_gandhi
    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
    rodnower
    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
    kiran.marla
    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
    zargon
    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
    zargon
    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
    laxman
    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
    FiZor
    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
    zargon
    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
    FiZor
    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
    zargon
    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
    rajavu
    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
    zargon
    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
    saracooper
    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: -
    zargon
    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

Forum Rules