With the aim of reducing mouse activity i was wondering if there was such a command shortcut (eg CLS or Ctrl+L) to provide the SQL*Plus (?) "CLEAR SCREEN" command functionality found by clicking the rubber-on-end-of-pencil icon in Oracle SQL Developer to clear the lower "Results" sub-tab (...incorrect terminology i'm sure). ...
Using SQLDeveloper 2.1.1.64, if you try typing the following code: DECLARE v_status_code NUMBER; v_status_text VARCHAR2(30); v_to_delete NUMBER := 5; BEGIN PACKAGE_NAME.Delete(v_to_delete, v_status_code, v_status_text); END; Pressing Enter after the PACKAGE_NAME.Delete(...) line will make Delete go into all caps (DELETE). I ...
I know this is a contrived example so please do not jump all over me for the uselessness of the code. This is an issue in more complex chunk of code but I wanted to isolate the I am having. The error I am getting is 'SQL Error: ORA-00933: SQL command not properly ended'. Any ideas? I am using SQL Developer by the way. Once again...this...
I have got one offer from MNC company for the post of SQL Server Developer. As such i am a programmer (in .net and SQL Server as back end).To crack the interview what topics i need to be aware of? (as there would be a difference in MS SQL used by programmer and a MS SQL Developer) Thanks! ...
Trying to generate an explain plan in SQL Developer, the program puts up a message box with title "failed to query plan_table" complaining "invalid column name". The plan is not generated or displayed. How to fix? ...
Oracle SQL Developer Version 2.1.1.64 Database created in MS SQL Server management studio 2008. computer name: server instance: sqlexpress DB name: equipment No security, or windows security I guess. what do I enter in the following sql developer fields: hostname, port, SID/service name. ...
EDIT: Clarified the question In MS SQL Server if I want to check the results from a Stored procedure I might execute the following in Management Studio. --SQL SERVER WAY exec sp_GetQuestions('OMG Ponies') The output in the results pane might look like this. ID Title ViewCount Votes ...
As a follow-up to the question "Get resultset from oracle stored procedure", is there a way to show the results of a stored procedure that returns a REFCURSOR in a grid (instead of the plain text Script Output window) within SQL Developer? EDIT: The answer helped, but I'm still having a problem displaying the result set in the "View Val...
I don't know where error information goes when a trigger doesn't work correctly. My tool for writing triggers has been Oracle's Sql Developer tool, and my knowledge of how to debug it is pretty much nonexistent. What are some pointers for being able to find useful information about things happening "behind the scenes"? Also, are the...
Hi, In Sql Server 2000 and 2005 I am running a select statement in a while loop. JFYI, this select statement is connecting to many linked servers and getting some values. IF there is any error, i want it should still execute next statement in the loop (similar to continue statement in c#) Example:- while @rowcount < 10 begin set @sq...
Platform: Oracle Language: PL/SQL Issue: Want to output a procedure OUT cursor into the SQLDeveloper SQLWosksheet. Anyone know how to use the Oracle "Select * from Table( PipelinedFunction( Param ) ) " to check procedure code output cursors? I am using Crsytal Reports off of an Oracle stored procedure. Crystal requires that a procedu...
I've searched through all of the responses on SQL Developer and I haven't found a response that matches this question. I need to be able to see the SQL for a table/view etc by clicking on the sql tab, but for now it simply shows me a blank screen. Has anyone else solved this? It works fine in toad and I can see the code but we have a ...
Hi, I am trying to run a stored procedure that has multiple in and out paramaters. The procedure can only be viewed in my Connections panel by navigating Other Users | | Packages | | If I right click , the menu items are "Order Members By..." and "Create Unit Test" (greyed out). The ability to "Run" the procedure does not seem possi...