Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.

"Syntax problem Oracle"

Post #303000783 by gandolf989 on Wednesday 19th of July 2017 04:06:45 PM

Full Discussion: Syntax problem Oracle
I am an Oracle DBA who has been writing PL/SQL for over 15 years. You should not need to learn explicit cursors. Perhaps your instructor wants you to understand explicit cursors but you should use implicit cursors instead. You can't select from an explicit cursor so that line won't work. You can use the c1%ROWCOUNT attribute. You may want to look at PL/SQL collections.

Using PL/SQL Collections and Records

Code:
SYS@test AS SYSDBA> CREATE OR REPLACE PROCEDURE TAB_ROW_COUNT
  2  AS
  3   tab_var  VARCHAR2(4000);
  4   ct_var   NUMBER;
  5   CURSOR c1 IS
  6      SELECT table_name FROM user_tables ;
  7  BEGIN
  8     OPEN c1;
  9     FOR I IN 1..7
 10     LOOP
 11        FETCH c1 INTO tab_var;
 12     DBMS_OUTPUT.PUT_LINE('c1%ROWCOUNT: '||c1%ROWCOUNT );
 13        DBMS_OUTPUT.PUT_LINE(tab_var);
 14  -- select count(*) into ct_var from tab_var;
 15  -- dbms_output.put_line('There are ' || ct_var || 'rows in' || tab_var 'table');
 16     END LOOP;
 17  END;
 18  /

Procedure created.

Elapsed: 00:00:00.01
SYS@test AS SYSDBA>
SYS@test AS SYSDBA> exec TAB_ROW_COUNT;
c1%ROWCOUNT: 1
TAB$
c1%ROWCOUNT: 2
CLU$
c1%ROWCOUNT: 3
IND$
c1%ROWCOUNT: 4
ICOL$
c1%ROWCOUNT: 5
COL$
c1%ROWCOUNT: 6
LOB$
c1%ROWCOUNT: 7
COLTYPE$

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.05

 
Related Linux and UNIX Technical Support
syntax problem
rajan_ka1
dear friends, I have a large size file containg two fields data like this *** **** 122 222 ***** ***** ***** ***** 232 233 i have file like this. i want to remove blank lines from file . i think awk is servive this problem i wrote a awk command but the error is...... Shell Programming and Scripting
3
Shell Programming and Scripting
syntax problem
rajan_ka1
Dear friends, I am writing shell script in csh . i want to make arthimatic operation in csh. i wrote sysntax like this. set val = 230 set tmp = `0.1 * $val + 300` echo $tmp but it is not working . anyone please give me syntax.... Shell Programming and Scripting
3
Shell Programming and Scripting
Oracle like syntax required
ShellBoy
m kinda new to unix. i have been trying to write a script where i am trying to switch between users. but the problem is that the syntax like USERNAME/PASSWORD (like oracle SCOT/TIGER) is not working. if i write su USERNAME then the script goes to the command prompt and asks for user to enter...... UNIX for Dummies Questions & Answers
0
UNIX for Dummies Questions & Answers
Problem with syntax using awk
ajincoep
Hi Guys, When below code is executed in script, I get desired output in output file. awk 'NR >= $start_line && NR <= 3' master_scriptlist.txt > $driver1/scriptlist.txtBut when i replace 3 with a variable end_line=3, I do not get ouput. See code below. Is there any problem with syntax awk...... Shell Programming and Scripting
6
Shell Programming and Scripting
Problem with if-else syntax
wbrunc
I'm calling the following if-else from nawk. But I keep getting an error at the "else". I've tried putting more brackets and ; but still I get complaints about the "else". Any ideas ? Thanks, wbrunc BEGIN { FS = "," ; OFS = "," } { if ( $8 ~ /A/ && $9 == B ) $1="4/29/2013" ; $2="J.Doe"...... Shell Programming and Scripting
2
Shell Programming and Scripting
OCI_SET_ACTION(3)														 OCI_SET_ACTION(3)

oci_set_action - Sets the action name

SYNOPSIS
bool oci_set_action (resource $connection, string $action_name)
DESCRIPTION
Sets the action name for Oracle tracing. The action name is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement is executed. The action name can subsequently be queried from database administration views such as V$SESSION. It can be used for tracing and monitor- ing such as with V$SQLAREA and DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE. The value may be retained across persistent connections.
PARAMETERS
o $connection -An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3). o $action_name - User chosen string up to 32 bytes long.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1 Setting the action <?php $c = oci_connect('hr', 'welcome', 'localhost/XE'); // Record the action oci_set_action($c, 'Friend Lookup'); // Code that causes a roundtrip, for example a query: $s = oci_parse($c, 'select * from dual'); oci_execute($s); oci_fetch_all($s, $res); sleep(30); ?> // While the script is running, the administrator can see the actions // being performed: sqlplus system/welcome SQL> select action from v$session;
NOTES
Note Oracle version requirement This function is available when PHP is linked with Oracle Database libraries from version 10 g onwards. Tip Performance With older versions of OCI8 or the Oracle Database, the client information can be set using the Oracle DBMS_APPLICATION_INFO pack- age. This is less efficient than using oci_set_client_info(3). Caution Roundtrip Gotcha Some but not all OCI8 functions cause roundtrips. Roundtrips to the database may not occur with queries when result caching is enabled.
SEE ALSO
oci_set_module_name(3), oci_set_client_info(3), oci_set_client_identifier(3). PHP Documentation Group OCI_SET_ACTION(3)

Featured Tech Videos