I have to make a program that will use fseek to read data from pirticular position. i have to read data line by line,and in pirticular line i have to use fseek to read data.
I am currently working on the process of automating the creation of store procedure and functions in oracle DB
I am trying to open a file residing in data base server, i used SELECT * FROM V$PARAMETER WHERE NAME = \'utl_file_dir\'
is ther开发者_如何学编程e any way to do a CASE WHEN INTO Statement? Create or replace procedure example
Are there any cases where an INSERT in SQL (s开发者_如何学JAVApecifically Oracle-PL/SQL) can fail without an exception being thrown?I\'m seeing checks in code after INSERT where it verifies that SQL%R
I\'ve created an \"instead of\" trigger for a simple view that only does select * on a table and a trigger that does nothing (I wanted to minimize the problem):
I have written a code in PLSQL. Where in I need to Check if sum of cubes of digits = to number itself.开发者_如何学编程
I have a query that queries on ReportStartDate and ReportEndDate so I thought I would use variables in PLSQL. Not sure what I am missing here, but I get an error:
I have a stored procedure, which returns a cursor. The application passes a parameter to the procedure which determines how many ID`s should be fetched, so the procedure doesnt know a head of time th
Write a program containing a loop that iterates from 1 to 1000 using a variable I, which is incremented each time around the loop. The program should output the value of I every hundred iterations (i.
加载中,请稍侯......