collection gives more fuctionality in different way..cursor is forward direction only we cannot back but in collection we can fetch data using collection method.
I get insufficient privileges error while trying to provide grants on those tables , I'm able to query those tables but I cannot access them through PL-SQL procedure . I'm Logged in through System user , I guess it should have all privileges to provide grants... Any suggestions ? I'm practicing on Oracle Express edition 11g . GRANT SELECT ON SYS.V_$SESSION TO INVENTORY1; GRANT SELECT ON SYS.V_$sesstat TO INVENTORY1; GRANT SELECT ON SYS.V_$statname TO INVENTORY1; ORA-01031: insufficient privileges 01031. 00000 - "insufficient privileges" I get above errors while being connected through SYSTEM . I had given below grants to inventory1 while creating it CREATE USER INVENTORY1 IDENTIFIED BY INVENTORY1; GRANT CONNECT, RESOURCE, DBA TO INVENTORY1; GRANT CREATE SESSION, GRANT ANY PRIVILEGE TO INVENTORY1; GRANT UNLIMITED TABLESPACE TO INVENTORY1;
Hi Steven, I appreciate your time to upload these tutorials, I suggest you add english subtitles to videos for non-english speakers people. Thanks!!!
Thanks, we will look into doing this.
Stephen you are so great. From your video only I understood the logic of limit clause in bulk colectt. You are amazing bro. Thanks to youtube.
Steven Sir, you are Awesome but Pls also Provide Subtitle I miss some of your Words its too difficult Understand the Missing Words...🙏 thanks again
Nice video...I would like to know the main difference between cursors and collections?
collection gives more fuctionality in different way..cursor is forward direction only we cannot back but in collection we can fetch data using collection method.
I get insufficient privileges error while trying to provide grants on those tables , I'm able to query those tables but I cannot access them through PL-SQL procedure .
I'm Logged in through System user , I guess it should have all privileges to provide grants...
Any suggestions ?
I'm practicing on Oracle Express edition 11g .
GRANT SELECT ON SYS.V_$SESSION TO INVENTORY1;
GRANT SELECT ON SYS.V_$sesstat TO INVENTORY1;
GRANT SELECT ON SYS.V_$statname TO INVENTORY1;
ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
I get above errors while being connected through SYSTEM .
I had given below grants to inventory1 while creating it
CREATE USER INVENTORY1 IDENTIFIED BY INVENTORY1;
GRANT CONNECT, RESOURCE, DBA TO INVENTORY1;
GRANT CREATE SESSION, GRANT ANY PRIVILEGE TO INVENTORY1;
GRANT UNLIMITED TABLESPACE TO INVENTORY1;
When you connect as SYSTEM, be sure to do as SYSDBA. Then your grant should work fine.
sir, thankyou
Can you give example of collection of record types
DECLARE
TYPE employees_t IS TABLE OF employees%ROWTYPE;
TYPE my_rec_t IS RECORD (n NUMBER);
TYPE my_Recs_t IS TABLE OF my_Rec_t;
Practically Perfect PL/SQL with Steven Feuerstein ... Thanks a lot Steve.. will keep you busy in coming days.. going through all your tutorials 😊
Hi Steven...Good info on collections..Very useful..Would you tell me how to download your demo.zip file..?
www.oracle.com/webfolder/technetwork/tutorials/plsql/sfdemo.zip.
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Helvetica; color: #555555; -webkit-text-stroke: #555555; background-color: #f6f6f6}
span.s1 {font-kerning: none}
@@PracticallyPerfectPLSQL Hey Steven, the link does not work anymore. Any other place that this archive file is available?
Hi, the resource (demo.zip) is not available on the shared link. Please share the working link again.
Please